Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have a problem. I have to load an weird excel file in which the column A has got some unique ID codes . (
A1040000 |
01040100 |
01040200 |
01040300 |
01040400 |
01040500 |
01050000 |
B1050100 |
01050200 |
01050300 |
01050400 |
01050500) |
And I DONT want to LOAD the lines which are ****0000, only the others
Thank you in advance and wishing you a happy new year
Another option...
LOAD *
FROM YourFile
WHERE NOT Field LIKE '*0000';
If you want to make sure there can only be four values before the 0000, then you want to do it this way:
LOAD *
FROM YourFile
WHERE NOT Field LIKE '????0000';
May be like this:
LOAD *
FROM ...
Where WildMatch([Column A], '*0000') = 0;
Another option...
LOAD *
FROM YourFile
WHERE NOT Field LIKE '*0000';
If you want to make sure there can only be four values before the 0000, then you want to do it this way:
LOAD *
FROM YourFile
WHERE NOT Field LIKE '????0000';
another one could be
z:
load * inline [
line
A1040000
01040100
01040200
01040300
01040400
01040500
01050000
B1050100
01050200
01050300
01050400
01050500)
]
where not line like '*0000'
;
Thank you all guys. I am overwhelmed from your quick and accurate responses