cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Azim
Level II

How to select row with specific criteria from left or right of digit string?

From example in sample.xlsx. I have a list of IDs. In my case, I have tens of thousands of those. I need to remove rows where number starts from "204". 

I tried using:

Data Table ("Sample") << Select Where ( Contains(:Sample ID, "240")) << Delete Rows;

 

But this will also select and delete even when "240" is in the middle of digit string. What do I do if I want to only remove when my Sample ID starts from 240?

 

 

1 REPLY 1
jthi
Super User

Re: How to select row with specific criteria from left or right of digit string?

Use Starts With() (or Ends With() if lookup from the end) instead of Contains()

-Jarmo