storing records in awk array

npatwardhan · #1 (**permalink**) 01-05-2009

hi i have a file as follows:

Code:

i want to store all these numbers in an array using awk.. so far i have:

Code:

awk '{for(i=1;i<=NR;i++) {a[i]=$1}} END {for(i=1;i<=NR;i++) {printf("%1.11f",a[i])}}' 1.csv > test

however, i am getting all values as zero in the "test" file..
appreciate any help.

cfajohnson · #2 (**permalink**) 01-05-2009

Code:
awk '
{ a[NR]=$1 }
 END { for(i=1;i<=NR;i++) printf "%1.11f\n", a[i] }
' 1.csv > test
Of course, if you just want to format the file:
Code:
awk '{ printf "%1.11f\n", $1 }' 1.csv > test

npatwardhan · #3 (**permalink**) 01-05-2009

ok thanks that worked..
here is what i want to do next. i have this file called test which has values as follows:

Code:

i have another file called data with multiple fields and records as follows:
(there are more columns but following is just a snapshot of the file)

Code:

col1  col2
1       1.4
2       1.6
3       1.7
4       1.8
5       1.9
6       2.0

i would like to get a file with entries as follows: (i am subtracting each row from the data file for the first column from the first entry of the first row in the test file)

Code:

col1         col2
1-1         1.4-2
2-1         1.6-2
3-1         1.7-2
4-1         1.8-2
5-1         1.9-2
6-1         2.0-2

so far i was trying something along these lines:

Code:

awk 'NR==FNR{for(i=1;i<=NF;i++) {a[NR]=$i;next} {b[NR]=$i;next} END {for(i=1;i<=NF;i++) {printf("%1.11f, %1.11f\n",a[i],b[i])}}' test data > try

i am trying to save all the rows from the test file in an array(a). how do i save the col1 and col2 values from the data file in an array and then use it to subtract values from array(a)? i want to stick to awk.
thanks

vgersh99 · #4 (**permalink**) 01-05-2009

I think that's what you want, but not 100% sure:

Code:

awk 'NR==FNR{
           a[NR]=$i
           next
       }
       {
           for(i=1;i<=NF;i++) 
              printf("%1.11f%c", $i - a[FNR], (i==NF) ? ORS : OFS)
        }
' test data

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
perl: storing regex in array variables trouble	xist	Shell Programming and Scripting	3	08-29-2008 09:07 AM
storing variables in array.Please help	nua7	Shell Programming and Scripting	7	07-17-2008 10:47 AM
Storing pointer array in C	arunkumar_mca	UNIX for Dummies Questions & Answers	1	08-23-2007 09:49 AM
Count No of Records in File without counting Header and Trailer Records	guiguy	Shell Programming and Scripting	2	06-07-2007 01:15 PM
Getting database records in an array	rawat_me01	Shell Programming and Scripting	2	05-07-2007 01:09 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by