Hello, I already looked around but couldn't find how to do this.
This is what I am trying to do
Data Table( "Untitled" ) << select where (contains(:column 1, "5_lbe/?"));
Basically I have a bunch of data like this: 5_lbe12333, 5_lbe88837 (just to give an example) etc So it would be great if i could do it like in SQL with a SELECT LIKE statement but i cannot seem to find something similar in JMP
Contains() would also work here, but unlike SELECT LIKE you cannot use wildcards.
Data Table( "Untitled" ) << select where (contains(:column 1, "5_lbe"));
would not only select all rows that start with "5_lbe" but also rows with "5_lbe" at any position within the string. Starts With() is more specific.