Shell Programming and Scripting

Both of your scripts are perfectly working on my data.

Thanks a ton for both of you.

Sid..

---------- Post updated at 11:49 PM ---------- Previous update was at 11:29 PM ----------

I have some files(.csv) with the following data(Example) in them.

Code:

A,1,X
B,2,Y
C,3,Z

Now I need the following output..

Code:

A,1,X
B,1,Y
C,2,Z

Where my second column got formatted as for my condition
(row1-row1)
(row2-row1)
(row3-row1)
...
So on.. and leaving all the other columns undisturbed.

I am really fond of using awk but still learning. so any help in this regard is highly appreciated.

Thanks

Moderator's Comments:

Please use code tags. Video tutorial on how to use them

I thought all your numbers are integers ,have this code revised

Code:

awk '$1=$1-1{print}' sample_file

Use FS=, OFS=, and change $1 to $2 and Bob's your uncle..

Code:

awk 'NR==1{v=$2}{$2-=v}1' FS=, OFS=, infile

--
PS. Please, please heed the code tags warnings. Check your forum inbox

Scrutinizer ,

Code:

awk '$1=$1-1{print}' sample_file

perfectly decrements value by one , have this tested taking decimal numbers as stated in the post .

The OP wants to decrement by the value of row 1, not just literal 1 (although the title and initial description say something else ).