Help : Create a text file in semi colon seperated format from yxdb file

[alt_tush]

Hi Team,

I need your urgent help here.

I have a yxdb file with blow type of data

Filed1  Filed2             Filed3             Filed4               Filed5       Filed6       Filed7   Filed8
X         09141             11/30/2017    12/7/2017       
Y         3B670931       24                  XYZ CO LTD    UK            478886   
Y         3B670931       24                  XYZ CO LTD    UK            478886   
Y         3B670931       24                  XYZ CO LTD    UK            478886   
Z         12345              25                 ABX,PVT LTD   US            123456    200        AUD
Z         12345              25                 ABX,PVT LTD   US            123456    200        AUD

I want to convert it into below format in text file (.txt) file

Output :-

X;09141;11/30/2017;12/7/2017;
Y;3B670931;24;XYZ CO LTD;UK;478886;
Y;3B670931;24;XYZ CO LTD;UK;478886;
Y;3B670931;24;XYZ CO LTD;UK;478886;
Z;12345;25;ABX,PVT LTD;US;123456;200;AUD;
Z;12345;25;ABX,PVT LTD;US;123456;200;AUD;
C;6;

In bold there is a comma in between the string. I need the value as shown as per the input.

Last row is the count of records i.e. 6 is the number of records in above data and character "C" is fixed. i.e. last row would be C;6

I need your urgent help here.

Waiting for your reply.

Thank you.

[alt_tush · Accepted solution]

OMG...

Its Work... Thank you Thank You Thank you so much Neil :) :) :)

Appreciate your all help to me.. :)

Have a good day :)

[LordNeilLord · Accepted solution]

@alt_tush Awesome!

Can you accept the solution for me?

Neil