Replace spaces with commas from one file and send the output to another file.
tr -s '[:blank:]' ', ' < input.txt > output.txt |
It’s perfect for creating a comma delimited file for importing to Excel.
spaces
Replace spaces with comma
Here’s a simple sed command to replace multiple spaces into a comma delimited file.
sample.txt
one two three four |
The sed command.
sed 's/ \+ /,/g' sample.txt > sample2.txt |
sample2.txt
one,two three,four |