Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a excel which have data lke
RegionName | RegionCode |
---|---|
A | ABO1 1,AB01 2,AC02 1,DB01 2 etc |
No i want the output as
RegionName | Regioncode |
---|---|
A | ABO1 1 |
A | AB01 2 |
A | AC02 |
A | DB01 2 |
A |
Can anyone help me to sorted out?
Thanks in Advance.
Try
LOAD
RegionName,
subfield( RegionCode, ',') as RegionCode
FROM YourTable;
Hi,
you can do a SubField in the script:
A:
LOAD RegionName,
RegionCode
FROM
C:\Users\ferrdani\Desktop\Community\Regions.xlsx
(ooxml, embedded labels, table is Sheet1);
B:
NoConcatenate
Load
RegionName,
SubField(RegionCode,',') as RegionCode
resident A;
Drop table A
Attached an example
Hi,
I have been using substring function for a long time, but never imagine it can be used without offset which will work as above requirement. Thanks for reminding mine old days to do exercise on functions again.
Thanks.