Shell Programming and Scripting

Hi everybody ,
I need someone to help me! I have a file with 4 colunms and I would like to transform only the 4th colunm by multiplying this by a constant value (i.e 0.3047). I'm a new one using/creating basic scripts and I'm using linux redhat.
The file has the following configuration (separeted by colunms):

Code:

115675.040000 9358616.700000 0.000000 4995,450195 
115675.040000 9358616.700000 50.000000 4995,450195
115675.040000 9358616.700000 100.000000 5008,660156
................. .................. ............ ...............
................. .................. ............. ...............

Is it possible to create in unix/linux a script to make this operation?
PS: The file is too big to do it the excel

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

---------- Post updated at 12:04 PM ---------- Previous update was at 12:01 PM ----------

Code:

nawk '$4*=mult' mult=0.3047