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?