Appending 'string' to file as first column.

Shell Programming and Scripting
1

Hi , I have the below file with 6 columns.I want to append 'File1' as the 1 column to the file. i have the sample code .It is not working . can u please correct this or make new one .....

awk 'print {'File1',$1,$2,$3,$4,$5,$6}' Source_File> Result_File

Source_File:

E100,0,5/29/1993,0,E001,E000
E102,0,1/23/1994,0,E001,E003
E104,0,6/4/1994,0,E001,E003
E105,0,7/30/1993,0,E001,E003

Result_File :

File1,E100,0,5/29/1993,0,E001,E000
File1,E102,0,1/23/1994,0,E001,E003
File1,E104,0,6/4/1994,0,E001,E003
File1,E105,0,7/30/1993,0,E001,E003

Please help me .....

2

try this:

awk '{ print "File1,"$0}' Source_File> Result_File
3 
 awk '{print "File1,"$1,$2,$3,$4,$5,$6}' Source_File> Result_File
4

sed 's/^/FILE1,/g' file1 > newfile

5

awk '{print "File1,"$1,$2,$3,$4,$5,$6}' Source_File> Result_File
:confused:
The code is useful ....but 'File1' is not appending . I tried many times...empty space is coming .....

 ,E100,0,5/29/1993,0,E001,E000
 ,E102,0,1/23/1994,0,E001,E003
 ,E104,0,6/4/1994,0,E001,E003
 ,E105,0,7/30/1993,0,E001,E003
6

Hi,

Try the below command. Hope this should work.

awk '{print "File,",$1,$2,$3}' Source_File | sed 's/ //g' > Result_File

Thanks,
:o

7

Working fine for me...

$ cat source
E100,0,5/29/1993,0,E001,E000
E102,0,1/23/1994,0,E001,E003
E104,0,6/4/1994,0,E001,E003
E105,0,7/30/1993,0,E001,E003

$ awk '{print "File1,"$1,$2,$3,$4,$5,$6}' source
File1,E100,0,5/29/1993,0,E001,E000
File1,E102,0,1/23/1994,0,E001,E003
File1,E104,0,6/4/1994,0,E001,E003
File1,E105,0,7/30/1993,0,E001,E003