Check if a column contains a substring
I would like to create a new column in using jsl based on a condition that involves 2 columns. I could describe in ordinary language it as follows: New Column( "Condition", Character, "Nominal", Formula( If( Column A contains substring "REF" then return Word(4, Column B, "_") else return Word(4, Column A, "_") ) )could you hel...