Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks, It's working !
Hi, load data with NAMESTRING field in this manner.
SubField(NAMESTRING, '|') as NAMESTRING
Thanks, It's working !