normalization 1

[ovince]

hi


I would like to normalize second column of dataFile to number at 1000 row of second column. I do this by looking what number I have in 1000th row of second column first and then

awk'{print $1, $2/23.45}' file

Must be an easier way to do this I am sure. some suggestions?

thanks

 

[Annihilannic]

What's the problem with that way?

Annihilannic.

 

[ovince]

there is no problem but I wanted to automatise the process since I have many files

 

[Annihilannic]

Oh, I see, I didn't realise you were doing that part manually.

Try this:

awk '
        NR == FNR && NR == 1000 { d=$2; nextfile }
        NR != FNR { print $1,$2/d }
' inputfile inputfile

Notice that inputfile is specified twice.

Annihilannic.