String to Hex , remove all special characters and back to String again

[former_member1048438]

Hi,

I have a table coming from Function Module in SAP HANA . the challenge is to Convert the string to Hex where to remove the special characters and Zero and then need to convert back to string.

Could anyone give me the solution.

Thanks,

GnREDDY

[former_member210482]

Hi Reddy,

How can a string conversion from string to hex will remove special characters? Is it possible

Regards,

Safiyu

[former_member210482]

Hi Reddy,

Anyways, you can create a calculated column to convert string to hex using rawtohex('String') function and unhex it back with hextoraw('hex_string').

Hope it helps.

Regards,

Safiyu

[former_member1048438]

Hi Safi,

Thanks for your interest in helping me.

I got solution by using string functions in HANA.

Thanks,

GnR

[former_member210482]

Hi,

This is what i was referring to. You cant remove any special characters by converting to hex. Because special characters also will be having corresponding hex code.

And yeah replace is a conventional way of removing unwanted characters. good to go..

Regards,

Safiyu

[former_member1048438]

Thanks Safi..