I'm newer with bash scripting. I have a regular txt file with three columns of data. I want to make this into csv format.
hagabe 3322 7/28/14
uenebh 3878 7/26/14
jheheb 5569 7/27/14
Making it look like:
hagabe,3322,7/28/14
I know I could take each column and make a file then use paste to create the csv but that seems like over kill. There has to be an easier way. Would it be logical to simply remove the spaces and add the comas? Any suggestions are appreciated!
Just use awk with OFS set to ,:
awk -v OFS=, '{$1=$1}1' file
Output:
hagabe,3322,7/28/14
uenebh,3878,7/26/14
jheheb,5569,7/27/14
$1=$1 is there to force awk to re-format the line using the output field separator. The NF condition is not strictly necessary.Through awk,
$ awk '{gsub(/ +/,",")}1' file
hagabe,3322,7/28/14
uenebh,3878,7/26/14
jheheb,5569,7/27/14
$ cat in
hagabe 3322 7/28/14
uenebh 3878 7/26/14
jheheb 5569 7/27/14
$ while read -ra line; do IFS=, eval echo \"\${line[*]}\"; done <in
hagabe,3322,7/28/14
uenebh,3878,7/26/14
jheheb,5569,7/27/14
tr '\t' ','