Separating Values while lookup

[Saro_2306]

Input:
load * Inline [
Col1, place

1,Area/Club

2,District

3,Country/Street
];

TAB2:
Load * Inline [
Col1
1
2
3
];

My Output should be like below:

1,Area

1,Club

2,District

3,Country

3,Street

Can anybody please help. Thanks in Advance.

[Frank_Hartmann · Accepted solution]

maybe like this:

Input:
Load *, subfield(place,'/') as place_new;
load * Inline [
Col1, place

1,Area/Club

2,District

3,Country/Street
];

TAB2:
Load * Inline [
Col1
1
2
3
];