convert spaces to commas

[ryanc2]

I need a simple awk or sed script to convert a text file with columns seperated by spaces to output to a .csv file.

Any help would be appreciated.

Thanks

 

[Wonboodoo]

cat <file_name> | sed 's/ */,/g' # Note two spaces before *

 

[vgersh99]

sed -e 's/[ ][ ]*/,/g' file
nawk -v OFS=',' '$1=$1'

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[ryanc2]

Thanks for the input.

Wonboodoo - How can I put quotes around so Excel will inport as text field and not strip leading zeroes? Also, is there a way to eliminate putting a comma before the first column (ends up importing a blank column in Excel).

Thanks again!

 

[vgersh99]

sed -e 's/^[ ][ ]*//g;s/[ ][ ]*/,/g;s/[^,]/\&quot;&\&quot;/g' file

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[vgersh99]

or with awk:

nawk -v OFS='&quot;,&quot;' '{$1=&quot;\&quot;&quot;$1; $NF=$NF &quot;\&quot;&quot;; print}' file

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[ryanc2]

sed -e 's/^[ ][ ]*//g;s/[ ][ ]*/,/g;s/[^,]/\&quot;&\&quot;/g' file

Vlad - This puts quotes around every character. What about each column:

12345,Name,12 --> &quot;12345&quot;,&quot;Name&quot;,&quot;12&quot;

Thanks again.

 

[vgersh99]

sed -e 's/^[ ][ ]*//g;s/[ ][ ]*/,/g;s/[^,][^,]*/\&quot;&\&quot;/g' file

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+