File Format Issue

[qliksus]

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.

[swuehl]

Try

LOAD

     RegionName,

    subfield( RegionCode, ',') as RegionCode

FROM YourTable;

[#3]

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

[qliksus]

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.