Shell Programming and Scripting

Hi All,
I have a comma seperated file.
I wanna remove the spaces from column 2. I mean i don't wanna remove the spaces those are presnt in column 1.

ex:
emp name, emp no, salary
abc k, abc 11, 1000 00
bhk s, bhk 22, 2000 00

the output should be:
emp name, emp no, salary
abc k, abc11, 100000
bhk s, bhk22, 200000

column 2 and 3 spaces needs to removed.
Can anyone has the solution for this problem.

Thanks:

Try this

awk -F "," 'OFS=","{gsub(/ /,"",$2);gsub(/ /,"",$3);print $1,$2,$3}' filename



cheers,
Devaraj Takhellambam

Hi devtakh,

Thanks for your quick reply.
But, the number of columns may differ from file to file.
I mean to say that the number of columns are not constant.
Could anyone please suggest any other way!!!

Thanks

awk -F "," 'OFS=","{first=$1;gsub(/ /,"",$0);$1=first;print $0}'


cheers,
Devaraj Takhellambam

Code:

# awk -F"," '{gsub(/ +/,"",$2);}1' OFS="," file
abc k,abc11, 1000 00
bhk s,bhk22, 2000 00

perl (5.8)

Code:

# perl -F"," -lane '$F[1]=~s/\s+//g;print join(",",@F) ' file
abc k,abc11, 1000 00
bhk s,bhk22, 2000 00