?

[xyz1]

.

[sunny_talwar]

Check this out

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

[xyz1]

.

[sunny_talwar]

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....

[adamdavi3s · Accepted solution]

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;