Dear all, I need a function for removing the wild char. I founded stripwi

Giobis over 12 years ago

Dear all,
I need a function for removing the wild char. I founded stripwith but it doesnt works well.
I wrote this expression:

=stripwith(ri!string,"\\,/,;,:,?,’,>,<,*,char(124)")

but if I wrote andrea the output is nde. Otherwise if I putting prova|test\\ the output is pov|test

Any suggestion ? Thanks a lot

...

Discussion posts and replies are publicly visible

Parents

0 mark.griffith
Appian Employee
over 12 years ago

Hi Gioachino, it is because char(124) is in quotes"" it will strip characters c,h,a,r,(1,2,4,). To resolve replace with =stripwith(ri!string,"\\,/,;,:,?,’,>,<,*"&char(124))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mark.griffith
Appian Employee
over 12 years ago

Hi Gioachino, it is because char(124) is in quotes"" it will strip characters c,h,a,r,(1,2,4,). To resolve replace with =stripwith(ri!string,"\\,/,;,:,?,’,>,<,*"&char(124))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data