Shell Programming and Scripting

Hi, i want to add another column to existing files containing strings and need to have the final output as a csv file. i have quite a number of files, each with varying number of rows and i need to append the string "test" for all the valid rows for each file. my sample raw files looks like this one:

Code:

123.1 12
123.2 12.1
123.3 12.2
123.4 12.3

my desired output is the one below:

Code:

test,123.1,12
test,123.2,12.1
test,123.3,12.2
test,123.4,12.3

any help and solution is greatly appreciated. thanks in advance.

Code:

awk '{gsub(/ /,",",$0); print "test,"$0}' infile

If you want to add a constant string "test" at the beginning of every string.. One way using Perl.

Code:

$ perl -lane 'unshift(@F,"test");print join(",",@F)' inputfile
test,123.1,12
test,123.2,12.1
test,123.3,12.2
test,123.4,12.3

This will work even if the columns are separated by any number of spaces (spaces, tabs).

Thank you guys, both ways very helpful as always,

Another way using sed. He, he

Code:

sed 's/^/test,/;s/ /,/' inputfile

Code:

 
sed -e 's/ /,/' -e s'/^/test,/' input.txt

hi, on the side, i need to save the new generated files into unique filenames:
if i do the loop on the final output if will be something like:

Code:

199901.csv

i want to save the final output as:

Code:

199901test.csv

how to i append the "test" part to the filename. thanks again