Shell Programming and Scripting

Hi All,

First, Thank you for your time and help.

Regarding the script. I need to compare two numerical values from a text file and if A<B write "1" to specific column location in the file(call this group variable). When A>B write "2" to specific column location. Every time the condition A>B is meet increment the Group value (+1).

Here is a part of the file hope this helps:
Values to be compared )in red ------------------------ Group variable (in green)

Code:

sc_2600                                                        1637.00   516418.17  2876882.65  10547.8604       1
sc_2600                                                        1637.20   516428.97  2876888.87  10547.0000       1
sc_2600                                                       11106.80  1016594.53  3193390.21   4565.5098      2
sc_2600                                                       11107.00  1016605.07  3193397.00   4565.1699      2
sc_2600                                                       11107.20  1016615.65  3193403.82   4563.9702      2

The values in red have to be compared line by line and if A<B is true write "1", once A>B is encountered increment(+1) the A<B "group value".

Is this achievable in bash script?
The way I see things and correct me if wrong.
1. Assign line 1 value from specific column to variable "A"
2. Assign line 2 value from specific column to variable "B"
3. Compare if A<B write group value of X (x =1) to specific column location.
4. if A>B X=X+1

Thanks

Moderator's Comments:

Please use code tags next time for your code and data, thanks

Is this a homework assignment?

What have you tried?

Not a homework assignment. So far I'm trying to figure out the best way to pass the numerical values from the text file to variables. Reading on "awk" and "sed"now. Then will look into comparing them. Also will need to figure out how to write a value to specific location.

Thanks

I can't follow what you're trying to do:
Please describe more clearly what you are trying to do:
Concentrate on awk rather than sed for this. The sed utility is not designed to perform arithmetic (like X=X+1) nor arithmetic comparisons (like A < B).

Don,

Thank you for your replay. My logic is wrong and will need to think about this more. I will repost once I have a everything together per your criteria.

Thanks again