Append space at end and convert comma to Spaces

itjagadesh · New User Joined: 05 Dec 2006 Posts: 89 Location: chennai

Team,
I have following requirement and need to do thru any of utilities.
Input file - Having LRECL 80 having employee number.

But input file record will have variable employee number (some record will have 2 employee num some of them have 3 etc separated by comma)

Ex
Input file having 3 record

123456,23456,45678,,,,,,,,,,,,,,,,,
456789,12345,,,,,,,,,,,,,,,,,,,,,,,,,,,
345677,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Output file should be like below

123456,23456,45678
456789,12345
345677

ie) i need to remove lall the comma ',' into spaces only at the end of each record.

Any utilities like sort ,fileaid should be fine.

Thanks
Jagadesh

Frank Yaeger · Posted: Tue Jun 21, 2011 10:21 pm

Assuming your input file has RECFM=FB and your account numbers have a maximum of 6 digits, you can use a DFSORT job like the following to do what you asked for:

itjagadesh · New User Joined: 05 Dec 2006 Posts: 89 Location: chennai

Thanks Much Frank .
Everything looks good except below one.

Comma (') missing in between employee number .

Below is the output coming now

1234562345645678
45678912345
345677

we are expecting in below format (ie need to remove comma only at end of all the records)

123456,23456,45678
456789,12345
345677

Please help me .

Thanks
Jagadesh

gcicchet · Posted: Wed Jun 22, 2011 7:34 am

Hi,

are you sure you have used exactly what Frank posted, I tried it and it works fine for me.

I'm also sure Frank would have tested it before posting his solution.

Gerry

Frank Yaeger · Posted: Wed Jun 22, 2011 10:34 pm

Jagadesh,

Yes, I tested my solution and it works as expected, so you must have changed something or have something different from what you said.

itjagadesh · New User Joined: 05 Dec 2006 Posts: 89 Location: chennai

Frank ,

Sorry for my late response.

First solution itself working fine for me. I gave the input account number in wrong format thats why not working. I corrected my input records and ran with first solution (parse ) and working fine.

Thanks much for your quick help.

Regards
Jagadesh