Shell Programming and Scripting

Hi,

I need to manipualte the data in the file below so that the value fields on each line are truncated to just two decimal places. Meaning i want to delet everything after two decimal places on each record in the file.

I have highlighted the first value field.

023318
14579359.6500000004

034899
1976138.6767000001

042012
80145145.4400000002

086543
12609500.3800000002

091559
34830963.3300000018

10
166784506.0399999991

11
884517456.5800000032

12
108694361.4000000014

132437
7035481.8500000004

159629
12770.06

17010
1083.84826


I can obviously use SED to find the decimal point, but can someone please advise on how to use cut in order to truncate the values after the decimal point as required ?

Thanks
Rgds

Paul

One method..assuming the file contents are of the given format.

Code:

sed 's/\(.*\)\.\([0-9][0-9]\)\(.*\)/\1.\2/' file

Code:

awk -F"|" '{ printf "%0.2f\n", $2 }' filename

change the delimiter as per requirement

Hi,

Thanks this works fine.

Rgds

Paul