I have a data set like bellow mentioned -
And I want the Output as below-
Can you please help me in getting this sorted.
SubField(No, ':') as No
(html, codepage is 1252, embedded labels, table is @1);
Retrieving data ...