Remove blank spaces

Gents,

Please can you help me.. to remove blank spaces :slight_smile:

Input

ABSOLUTE  , ,FALSE  ,1035  ,28  ,669  ,1817.0  ,CORREL BEFORE  ,1  
ABSOLUTE  , ,FALSE  ,1035  ,28  ,686  ,1817.0  ,CORREL BEFORE  ,1  
ABSOLUTE  , ,FALSE  ,1035  ,28  ,670  ,1819.0  ,CORREL BEFORE  ,1  
ABSOLUTE  , ,FALSE  ,1035  ,28  ,687  ,1819.0  ,CORREL BEFORE  ,1  

Output file desired

ABSOLUTE,,FALSE,1035,28,669,1817.0,CORREL BEFORE,1
ABSOLUTE,,FALSE,1035,28,686,1817.0,CORREL BEFORE,1
ABSOLUTE,,FALSE,1035,28,670,1819.0,CORREL BEFORE,1
ABSOLUTE,,FALSE,1035,28,687,1819.0,CORREL BEFORE,1

Thanks in advance :b:

Removal of the blanks around the commas:

perl -i -pe 's/\s*,\s*/,/g' file
1 Like
 sed 's/ *,/,/g' file
1 Like

awk version

awk -F" +," '{$1=$1}1' OFS=, file
1 Like

Thanks to all ,, your help is appreciated :slight_smile: