how to subtract selective values in multi row multi column (awk or sed ?)
I have a problem where I need to make this input:
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!