unable to use regex function to compare to variable
Apr 23, 2019 8:27 AM(1760 views)
Hi all , i facing a problem to compare to string inside a variable. This works well when i dont use varialbe , can somemore please help ? The result is always "." even though it one string is a substring of another.
It would help if you could show a few rows of the data table or give examples of values for stepproduct and step. What are the values of these values prior to calling the If() function? Also, are they both numbers?
Do you mean the result of the Regex() function, the Substitute() function, or the If() function is missing?
This case is simple and will certainly work with the correct regular expression, it might be easier to use the Contains() function.