CI-DS - Special Character handling - TAB

[vivekkrishnan]

How to remove Special Character Handling for replace TAB ? 

CHR(9) does not work. 

Reference Note - 2007254 - How to Resolve Special Character Errors when loading data to SAP Sales and Operations Plan...

[peter_casper]

Hi @vivekkrishnan,

the template data flows in CI-DS use the following logic to replace the documented special characters.

ifthenelse(ltrim_blanks(translate(QueryAndFilter."YOUR_SOURCEFIELD", CHR(10) || CHR(13) || CHR(39) || '"<>', '      ')) = '', 
                NULL,
              translate(QueryAndFilter."YOUR_SOURCEFIELD", CHR(10) || CHR(13) || CHR(39) || '"<>', '      '))

I would add CHAR(9) and CHAR(11) to the list of non-displayable ASCII characters, separated by double pipe signs.

This should theoretically work from my pov.
BR, Peter