Shell Programming and Scripting

Hi All,

This is my first thread. Hopefully you guys can help me out. I have a csv file, that provides access to managers to a tool. The file is loaded onto our server containing all the assc id's with a trailing comma.

For ex: 182950,
123456,
However, we receive a file that contains 2 trailing commas instead of 1 like 182950,, . Due to this we faced a production failure.

We need to write a code to remove the extra commas after the id. The file contains above 3000 id's and every id should have only 1 trailing comma.

Thanks in advance.

Try something like:

Code:

sed 's/,,$/,/' file

Code:

sed 's/,,$/,/' file

Thanks. If we receive a file with dynamic commas, say some ids are trailed with 2 commas and some with 3 so how can I change the complete file to have only 1 trailing comma. As the above logic will work when we have only 2 trailing comma.

Code:

sed 's/,*$/,/' file

if supported with your sed:

Code:

 sed 's/,\+$/,/'

or

Code:

perl -lpe 's/,+$/,/'

sed 's/,*$/,/' In case you want to employ the technique in another instances, this one has the advantage or disadvantage that it would add a trailing , if none is found

Thanks very much Don and Aia. Really appreciate the advice. Will try all the solutions given, hopefully they will solve my problem.