Contains formula returns a -1 when I expected 1 or 0

[tstrong]

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?  

[JosephSerpis · Accepted 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

[tstrong · Accepted solution]

Thank you