Unix remove white spaces/tabs before & after pattern

Shell Programming and Scripting
1

Hi All,

I wanted to know is there any way we can remove white spaces/tabs before & after some pattern { eg. before & after "," }.

Please find below sample data below,

Sat Jul 23 16:10:03 EDT 2011   ,    12345678 , PROD     , xyz_2345677          , testuuyt                       ,      149693 , abtryu
Jul 22 2011                    ,        NULL , PROD     , yt12345              , testuuytoy                     ,      162469 , abtryu
Jul 22 2011                    ,        NULL , PROD     , yt12345              , testuuytoy                     ,      162469 , abtryu
Jul 22 2011                    ,        NULL , PROD     , yt12345              , testuuytoy                     ,      162469 , abtryu
Jul 22 2011                    ,        NULL , PROD     , yt12345              , testuuytoy                     ,      162469 , abtryu
Jul 22 2011                    ,        NULL , PROD     , yt12345              , testuuytoy                     ,      162469 , abtryu
Jul 22 2011                    ,        NULL , PROD     , yt12345              , testuuytoy                     ,      162469 , abtryu

Please help.

2

Hi,

Using 'perl':

$ perl -pe 's/\s*,\s*/,/g' infile
Sat Jul 23 16:10:03 EDT 2011,12345678,PROD,xyz_2345677,testuuyt,149693,abtryu
Jul 22 2011,NULL,PROD,yt12345,testuuytoy,162469,abtryu
Jul 22 2011,NULL,PROD,yt12345,testuuytoy,162469,abtryu
Jul 22 2011,NULL,PROD,yt12345,testuuytoy,162469,abtryu
Jul 22 2011,NULL,PROD,yt12345,testuuytoy,162469,abtryu
Jul 22 2011,NULL,PROD,yt12345,testuuytoy,162469,abtryu
Jul 22 2011,NULL,PROD,yt12345,testuuytoy,162469,abtryu

Regards,
Birei

1 Like
3

Through Sed..

sed 's/ *, */,/g' inputfile
1 Like
4

Thanks a lot ... both ways worked perfectly.