Replace all the Non printable special Characters in SAP HANA table

[ch_venu]

Hi I have a Column in Table in SAP HANA which is having the special Characters, I want to remove all the special characters from that.

[Abhishek_Hazra · Accepted solution]

Hi ch.venu,

You can use the following syntax

replace_regexpr('([^[:print:]]|[#%$|@!''?~"&^()*])' IN "<FIELD_NAME>" with '' OCCURRENCE ALL )

You can modify the [#%$|@!''?~"&^()*] section based on your requirements. For more detailed explanation refer to the following blog :

Removing invalid and non-printable characters in HANA based BW transformation.

Hope this information helps.

Best Regards,
Abhi

[Abhishek_Hazra · Accepted solution]

Hello ch.venu,
Did the suggestions help you out? If not you are free to come back with the issue you are still getting. Else would you mind respect the community guidelines to accept the correct/helpful answer & close your question? I could see you have asked questions in past & neither have acknowledged the answers responded to you, nor closed them. Not kind.

Acceptance of the answers not only motivates other members to answer the questions, also help others to find others to find the solution searching for the similar answer.

Regards,
Abhi

[mgregur]

Hi,

did you try using the REPLACE function?

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/20e66a2c75191014bac6a27995...

BR,

Matija