cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1019
Views
0
Helpful
2
Replies

ICM If Node

paulafdx
Level 1
Level 1

Is there a symbol that I can use in an "IF" node that is used to represent any possible character, number, etc... or set of numbers that might appear after a value?  Such as the use of the % in an SQL query. If i wanted to identify any data/value where the prefix is "167207....", but the .... could be any other string of numbers that i do not want specifically capture.  The prefix will always be the same value but the outlying numbers may change.  Thank you for your support

1 Accepted Solution

Accepted Solutions

Slavik Bialik
Level 7
Level 7

You can easily use the "left" function.

Like that:

left(Call.user.variable, 6) == "167207"

 

It'll take the 6 left characters and will compare it to "167207".

View solution in original post

2 Replies 2

Slavik Bialik
Level 7
Level 7

You can easily use the "left" function.

Like that:

left(Call.user.variable, 6) == "167207"

 

It'll take the 6 left characters and will compare it to "167207".

Great TY very much.  I knew there had to be an easy way to do this.  Thank you for your quick response