topic Re: How to show values of same patterns? in QlikView

?

xyz1 — Sun, 14 Apr 2019 14:16:08 GMT

Re: How to show values of same patterns?

sunny_talwar — Fri, 24 Mar 2017 09:48:34 GMT

Check this out

http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/

?

xyz1 — Sun, 14 Apr 2019 14:16:42 GMT

Re: How to show values of same patterns?

sunny_talwar — Fri, 24 Mar 2017 11:17:38 GMT

I have not used this before, but I knew something like this existed... won't be able to offer any more help on this topic....

Re: How to show values of same patterns?

adamdavi3s — Fri, 24 Mar 2017 12:17:00 GMT

This is a simple way of doing it...

EDIT This is simpler:

source:
LOAD [Account Name]
FROM

(ooxml, embedded labels, table is Sheet1)
WHERE IsNum(left([Account Name],7)) =-1 AND  Match(Mid([Account Name],8),'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') >0;

source:
LOAD *, IsNum(left([Account Name],7)) as numtest, Match(Mid([Account Name],8),'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') as alphatest;
LOAD [Account Name]
FROM

(ooxml, embedded labels, table is Sheet1);


NoConcatenate
Output:


LOAD *
RESIDENT source
WHERE numtest =-1 AND alphatest >0;


DROP table source;