How to remove unwanted characters from text ?

Certified Associate Developer

Hi ,

How to remove unwanted characters from text ?

 I get data from excel where its having char(9), char(160) sometimes different char(x) which none can expect

example: \tHello ( In Appian value : fn!char(9)Hello )

I want only Hello from the value. To use stripwith, char(160), char(10) etc.. would come in value which I can't expect

How can I achieve only wanted text or How can I remove those unwanted characters ?

  Discussion posts and replies are publicly visible

Parents Reply Children