I am using an inline_mapping_table and then a "map substring" function to abbreviate the individual segments that a Label (the Label of a cost Center) is made up from. That worked fine up to now.
Now I had the two Labels "KT Kasse / Kunde" which I wanted to make into "KT Kasse/ Kunde" (just getting rid of one blank) and "KT Konditionen / Provisionen" which I wanted to likewise make into "KT Konditionen/ Provisionen".
I was told that in an inline_table I have to use double_quotes to deal with blanks because a bracket would Close the inline_LOAD. That did not work up to now.
What do I have to do to make that work?
I can of course get the same effect using a REPLACE() function around my "MAP Substring", but I don't really want to start down that way - I had a series of nested REPLACE() functions at first, before I got the hint here in the community to use MAP SUBSTRING.