How to remove # special character in HCI-DS?

[Former Member]

Hello,

How do we handle # - hatch special character in Product Description or Customer Description, while loading Product and Customer?

I know Gita had already provided the syntax for taking care of all other special characters, but looks like # is missing in that syntax.

Pl help.

Thanks,

Mangesh

[virendrakumar_soni · Accepted solution]

Hi Mangesh,

you can simply use the replace_string function.

replace_string(Input_String,'#','')

you can replace the "Input_String" with the syntax Gita provided.