How can I concat Subfield ?

[suzel404]

Hi all,

I have a Label field like : 000 - Problem Network + Operational + Echange Control Balance for the ID 16.

How can I obtain the field Label like this (in column not inline)

Label:

Problem Network

Operational

Echange

Debit

Echange Control Balance

Echange Fees

Echange OFF

Echanges ON

Thanks for your help.

Regards,

[swuehl · Accepted solution]

Maybe like

LOAD

ID,

Label,

Trim(Subfield(Replace(Label, '-','+'),'+')) as SUB

FROM ConcatSubfield.xlsx (ooxml, embedded labels, table is Sheet1);

[suzel404]

Hi Swuehl,

It is exactly what I need.

Thank you !!