topic Re: 6hPkcFQn in QlikView

6hPkcFQn

Thu, 08 May 2014 21:23:32 GMT

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.

Re: 6hPkcFQn

Thu, 08 May 2014 21:38:24 GMT

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

Re: 6hPkcFQn

MarcoWedel — Thu, 08 May 2014 22:03:33 GMT

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

Re: 6hPkcFQn

Thu, 08 May 2014 23:59:57 GMT

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