Changing The data in a table

[Selis]

Hi,

I have a data table consisting of two fields:
OPNAME, NAMESTRING (This field consists of names separated by the sign "|")

For example:
OP1 "ABC|ABB|CVV"
OP2 "VGB|ABB"
OP3 "GGG"
I want to reverse the table so that it appears in the following format:
OP1 ABC
OP1 ABB
OP1 CVV
OP2 VGB
OP2 ABB
OP3 GGG

Thanks to anyone who can help how to do this.

[BrunPierre]

Hi, load data with NAMESTRING field in this manner.

SubField(NAMESTRING, '|') as NAMESTRING 

[Selis · Accepted solution]

Thanks, It's working !