6hPkcFQn

[#1]

I use *###* I find the data that is separated by the delimiter in a list.  Is there a way to search the data inside of the delimiter from left to right or the numbers at the start instead of pulling numbers in the middle of a larger number?  I want to find the numbers that start with 250.  Unfortunately, *250* pulls numbers that have 250 in it as well as the number that start with 250.

[#2]

Did you try 250*. Sorry if I missed something.

[MarcoWedel]

Hi Richard,

one solution could be:

tabInput:
LOAD * INLINE [
    valuelist
    123456 / 250678 / 234567 / 250123/ 250234/ 345678 / 456789 / 567890 / 250567
];

tabOutput:
LOAD *
Where number like '250*';
LOAD
  Trim(SubField(valuelist, '/')) as number
Resident tabInput;

hope this helps

regards

Marco

[#4]

This helped me experiment and find that if I include the delimiter inside of the ** (i.e. *|250*) then it will only find those numbers that have the delimiter in front of it.  This effectively makes it so I am able to pull just those numbers that start with 250 and not the numbers with it buried in it