Split column in Excel on | delimiter

[#1]

Hi.

I have the attached excel, and I need to get the "Licensed Products for Account" field to show values individually, because now it is one long string.

It is delimited on the | character

I need to do this in the script.

Any ideas?

[felipedl · Accepted solution]

Hi Aaron,

Use something like this

data:

LOAD [DMSi Customer ID],

     SubField([Licensed Products for Account],'|') as [Licensed Products for Account],

     [NPS Owner],

     [NPS Owner Date],

     [NPS Sys Mgr],

     [NPS Sys Mgr Date],

     [Type of Site]

FROM

(ooxml, embedded labels, table is Export);

Felipe.

[#3]

I figured it was with subfield. Thanks!