unable to use regex function to compare to variable

kuannygoh

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.  

 

If( regex(char(stepproduct),char(step),"1")=="1",
				stepproduct = Substitute( Char( stepproduct ), step, "" );
				tableExist = 1;
			,
				tableExist = 0;
			)

Mark_Bailey

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.