05-14-2019 07:20 AM
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
Solved! Go to Solution.
05-14-2019 07:57 AM
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".
05-14-2019 07:57 AM
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".
05-14-2019 08:32 AM
Great TY very much. I knew there had to be an easy way to do this. Thank you for your quick response
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide