How would I unwrap a field that has two or more information in the same field?

[#1]

How would I unwrap a field that has two or more information in the same

field?

  Example:

I have in qvd:

  [Number provider]        [Number personal]

          XYX; ABC                     12345

How to i need:

[Number provider]        [Number personal]

          XYX                             12345

          ABC                             12345

Any idea?

[maxgro · Accepted solution]

SCRIPT

Source2:

LOAD * INLINE [

Number provider,        Number personal

XYX; ABC,                     12345

];

Table2:

NoConcatenate

load trim(subfield([Number provider], ';', 1)) as [Number provider], [Number personal] resident Source2;

//load left([Number provider], index([Number provider], ';')-1)  as [Number provider], [Number personal] resident Source2;

concatenate (Table2)

load trim(subfield([Number provider], ';', 2)) as [Number provider], [Number personal] resident Source2;

DROP Table Source2;

RESULT

Number personal	Number provider
12345	ABC
12345	XYX

[#3]

Thanks!