UNIX for Advanced & Expert Users

Really nice of you Joeyg, But I need a permanent solution or script to attach for this flat file whereby everytime we get it we can clean it up. Sorry to bother but do u have any clues.thanks

also I tried sed "s/ ,/,/" test.csv>tes1.csv

this one stays no clue why

i tried with echo too but the space stays ...........what is it god knows?

joeyg has provided the solution for your problem ...

if you are not sure what it is
you can open file in VIM then do ":set list" make sure you are not in insert mode.

if you are still not able to make out again in vim go to the place where there is something you dont want and type "ga" which will display hex/octal value for same . use perl command to remove this hex/octal value.

Maybe you have a tab character before a comma. Try one of these commands, to remove a space or a tab before a comma:

Code:

sed -e 's/ ,/,/g' -e 's/\t ,/,/g'

or

Code:

awk '{gsub("[ ,|\t ],", ",")}1'

Regards

i got it working