Hi,

I have a problem where I need to make this input:

nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a
nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b

look like this output:

nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a - floatValue2b),...,(floatValue140a - floatValue140b)

I thought I could do this in awk, but I can't figure out how to read the 2 lines independently and assign them into arrays, to later be manipulated.

Any help is greatly appreciated, and thanks a lot in advance!

I think you will need to explain further?

1. Are we assigning to arrays in awk or bash?

2. How does your example work with being stored in an array?

3. Please show your efforts to solve

Sorry, I hadn't replied, but I found this piece of code would do the trick. Thanks

BEGIN {OFS = ",";}
{
nLine1 = split($0, Line1, ",");
getline;
nLine2 = split($0, Line2, ",");
getline;
for (i=1;i<=20;i++) $i = sprintf("%s", (Line1[i]) );
for (i=21;i<=141;i++) $i = sprintf("%.18f", (Line1[i] - Line2[i]) );
print;
}

1 members found this post helpful.