UNIX for Dummies Questions & Answers

Hi,

I have a file with 6 columns. First 3 columns together make unique record. I have a variable ($v) which hold a value that is obtained by a caliculaion. I have to replace value in 5th columnn with the value of the variable ($v). The value $v is caliculated from col4 and col6 values.

Record1: A|B|C|1|2|3
Record2: D|E|F|4|5|6

I know to do this is a database:
update table table_name set col_5=x where col_1=A and col_2=B and col_3=C.

But I dont have a clue how to do it in a file. It seems like find and replace. But I have to find ABC record and replace 5th column of the record with value in $v.


Please suggest.

Thanks and Regards,

Something like this?

Code:

awk 'BEGIN{FS=OFS="|"} 
$1=="A" && $2=="B" && $3=="C"{$5=value}
{print}' value=$v file

Regards

Thank you very much Franklin52. Its working.