changing column values - sed/awk?

[colsablue]

Please help - need a quick program to change the 3rd column from whatever to another value, globally - does anyone know how to do this qiuckly?

02 1314 4 100 39
02 1315 4 091 01 1 1
02 1315 4 091 05 549
02 1316 4 091 10 0 3

Thanks

 

[vgersh99]

nawk -v col=3 -v new=15 -f colsa.awk colsa.txt

#-------- colsa.awk
{
$col = new; print
}


vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[colsablue]

Cheers mate, thanks. Do you know how to do it if the original is had 'tabs' instead of 'spaces' between the columns?

Thanks again

 

[vgersh99]

nawk -v OFS=$(echo '\t') -v col=3 -v new=15 -f colsa.awk colsa.txt

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[colsablue]

Brilliant - Thankyou !

 

[futurelet]

Succinct:
[tt]
awk -f colsa.awk OFS="\t" col=3 new=15 colsa.txt
[/tt]