UNIX for Dummies Questions & Answers

Hi everybody,

I've got a file with 36074 fields. I need to insert an additional new columns 2,3,4 and 5 after the first field. The columns to insert are the same for all the lines: it's "1" doe the new field 2 and "0" for the rest. I did have a look in the forum and the suggested solution I found was something like this:

Code:

awk 'BEGIN {OF=OFS="\t"} {print $1, "1", "0", "0","0", $2, $3, $4}' file1 > file2

In this example the original file has only 4 fields, but I can't type all the 36074 fields :-(

Any suggestion would be greatly appreciated!

Code:

awk 'BEGIN{FS=OFS="\t"}{$1=$1 "\t1\t0\t0\t0"}1' file1 > file2

Assuming tab separated fields:

Code:

awk '$1 = $1"1\t0\t0\t0"' OFS='\t' infile

Many thanks Radulov!
I've tried it out and there're some problems:
1. the added column at the field 2 appears exactly after the first column, there's no separator (of any kind);
2. some lines don't have an entry for each column, so those just jumped to forward

Example:

my old file:

Code:

a b c d
e    f g
c      e
t y u o

new file:

Code:

a1 0 0 0 b c d
e1 0 0 0 f g
c1 0 0 0 e
t1 0 0 0 y u o

Many thanks in advance for any ideas!

---------- Post updated at 10:26 AM ---------- Previous update was at 10:10 AM ----------

I've just tried out the command posted by Danmero and it works!
Many, many thanks for your kind help!

Try:

Code:

sed 's/^[^ ]* /&1 0 0 0 /' infile

Thanks Radulov!
Unfortunately, this code adds 1 only and there're no columns 3,4,5 with zeros. Sorry :-(

Code:

# cat file
a b c d
e    f g
c      e
t y u o
# awk '{$1=$1 "1 0 0 0"}1' file
a1 0 0 0 b c d
e1 0 0 0 f g
c1 0 0 0 e
t1 0 0 0 y u o