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
3 replies
Subscribers
7 subscribers
Views
1192 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
can anyone suggest me how do i count no of delimiters in the Subject? For ex:Fir
nimishan
over 9 years ago
can anyone suggest me how do i count no of delimiters in the Subject? For ex:Firm Add|Test|Test|England||qw||qwee|Non Clearing|No|Yes||a537459@fmr.com| it should be13
Thanks in advance....
OriginalPostID-125743
OriginalPostID-125743
Discussion posts and replies are publicly visible
0
nareshs427
Certified Senior Developer
over 9 years ago
You can use the following expression if the delimiter is same..
=len(ri!text1)-len(stripwith(ri!text1,"|"))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
nareshs427
Certified Senior Developer
over 9 years ago
Here is another..len(cleanwith(ri!tex1,"|"))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
nimishan
over 9 years ago
Thanks a lot and it is working fine
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel