Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
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;
.
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....
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;