Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
7 subscribers
Views
2399 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Dear all, I need a function for removing the wild char. I founded stripwi
Giobis
over 11 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
...
OriginalPostID-71473
OriginalPostID-71473
Discussion posts and replies are publicly visible
Parents
0
mark.griffith
Appian Employee
over 11 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 11 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