Splitting column values with wildmatch condition.

[#1]

I have a column called Country with values as below

Country

US,MX,CH

CH

MX,BR,IND,

SA,NA,US

Using wild match How can i make these column values as individual columns like US,MX,CH,BR,IND,SA,NA

[#2]

I tried this.

subfield(subfield(Subfield([Country],','),';'),' ') as [Country]

[sunny_talwar · Accepted solution]

Not sure what you mean, but may be this:

Table:

LOAD Trim(SubField(SubField(Country, ','), ';')) as Country;

LOAD * Inline [

Country

US,MX,CH

CH

MX,BR,IND

SA;NA;US

] (delimiter is |);

[#4]

thank you very much.

[#5]

Is the below doable ?Thank you.

I have a column called States.

STATES

AL

GA

MI

SFO,SAN,WD,MI

MD;SAN

FL

Note:I have , and ; and space within the values.SFO,SAN,WD,MI has ',' in between where as MD;SAN has ';' in between and also

before GA there is a space.

How can I group this column values as below.SFO and SAN should fall under CAL.So,here new row called CAL gets created for SFO and SAN.

STATES

AL

GA

MI

WD

MD

FL

CAL