cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
Azim
Level I

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