how to bring data seperately?

[diwaskarki]

I have a straight table and a list box. Data in the straight table is displayed according to the filter in the list box. Below is a snapshot.

As you can see in the Master DSA List straight table, I have multiple DSAs in the same row.

This is my script to bring in the DSA.

TextBetween(Replace(Replace(Replace(Replace(ATTRIBUTES, chr(10), ''), ' ', ''), '<String>', ''), '</String>', ','), '<entrykey="SFGROUPOWNER"><value><List>', '</List>') As MAGroupOwners,

MAGroupOwners is renamed as DSA.

What can I do in the script to bring each MAGroupOwners separately in each row? Also, how can I do the same thing in the straight chart? I would really appreciate the help.

[jonathandienst · Accepted solution]

This will create one record per DSA:

LOAD

  Application,

  Entitlement,

  [Entitlement Description],

  SubField([DSA(s)], ',') As DSA

FROM ...

[vishsaggi]

You mean you want those comma separated values as separate rows? Eg. JLIO, LU5B? May be use

Subfield() Function around your textybetween like

Subfield(textbetween(Replace....)), ',')) AS MAGroupOwners

[diwaskarki]

Thanks Jonathan.