HCI DS - Special Character handling

[Former Member]

Hi,

Any idea on how to handle special chars

Single Quote '

Double Quote "

I was able to handle < & > signs but could not handle quotes.

Below mentioned mapping is used for description field.

ifthenelse(match_pattern(ABAP_Query.NAME1,'<') > 0,replace_substr(ABAP_Query.NAME1,'<','_') ,ifthenelse(match_pattern(ABAP_Query.NAME1,'>') > 0,replace_substr(ABAP_Query.NAME1,'>','_'),ABAP_Query.NAME1))

We are replacing special chars by underscore symbol.

Thanks,
Purav

[Alecsandra · Accepted solution]

Hi Purav,

Below is an example of the transform I have been using in mapping the fields within the target query:

replace_substr(

   replace_substr(

      replace_substr(

         replace_substr(

            replace_substr(

               replace_substr( <provide field name>, CHR(39), ' '),

CHR(13), ' ' ),

CHR(10), ' ' ),

'"', ' '),

'>', ' '),

'<', ' ')

Regards

Alecsandra

[Former Member · Accepted solution]

Hi,

Thanks.

CHR(39)

CHR (13)

CHR(10)

represents which special chars?

Thanks,

Purav

[Alecsandra · Accepted solution]

Hi Purav,

In the release note 2037139 there are mentioned some non printable ascii characters. Within DS syntax they are represented as follows:

- carriage return (CHR13)

- empty line (CHR10)

- simple quotes (CHR39)

Regards,

Alecsandra