Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have some series like this
IWG10SAD0260000 |
IWG10SAD0280000 |
IWG10SAD0250000 |
IWG10SAD0050000 |
IWG10SAD0290000 |
IWG10SAD0060000 |
IWG12GAN0150000 |
IWG12BAR0010000 |
IWG12BEH0010000 |
IWG12BHA0030000 |
IWG12BET0050000 |
IWG12BET0030000 |
IWG12ADO0020000 |
IWG12BET0040000 |
IWG11VAJ0400000 |
IWG11VAJ0320000 |
IWG11VAJ0310000 |
IWG11VAJ0330000 |
IWG11VAJ0300000 |
Now I want only those number which start from IWG11 and IWG12.
How I can do it from edit script.
Thanks & Regards,
A Kumar
Maybe like
LOAD
FIELD
FROM TABLE where FIELD like 'IWG11*' or FIELD like 'IWG12*';
Maybe like
LOAD
FIELD
FROM TABLE where FIELD like 'IWG11*' or FIELD like 'IWG12*';
Hi,
You can try somthing like this,
Load
Data
from Sample.xls
where left(Data,5) = 'IWG11' OR left(Data,5) = 'IWG12';
Regards,
Alex