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

Azim — Wed, 21 Aug 2024 11:25:29 GMT

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?

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

jthi — Wed, 21 Aug 2024 11:28:25 GMT

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

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

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

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