When using the Contains function, I get a return of -1 when the string is found. I was expecting a 1 or 0. Why -1?
Solved! Go to Solution.
Hi @tstrong that is expected this in the documentation for the contain function "Returns the 0 based index of the first occurrence of Target in String. Returns -1 if no occurrence" Link if you want to read more detail about it https://help.alteryx.com/2018.2/Reference/Functions.htm
Thank you