Remove duplicate commas after exporting excel file to csv

Shell Programming and Scripting
1

Hello everyone I'm new here and this is my first post so first of all I want to say that this is a great forum and I have managed to found most of my answers in these forums : )

So with that I ask you my first question:

I have an excel file which I saved as a csv. However the excel file contained several blank columns (they will be updated later so I cannot delete them).
The csv file looks like this:

AVAE34-IS1472-2P01.1,In Service,AMM 2PB,somsrv01,12713,AVAE34-IS1472-2P01,MTN12713,1,,,,172.17.213.145,,161,,,null,ISHB05_MECIDIYEKOY_172.17.213.XX.5,,,,,,,,,,,,,,,,control_user

Is there a sed command I can execute to delete these repeating commas?

I tried this one:

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

but it didn't work.

Thanks guys.

2 
 tr -s ',' ',' < inputfile
3

Try:

sed -e "s/,,*/,/g"
1 Like
4

thank you very much it worked like a charm!