08-17-2007
2,
0
Join Date: Jul 2007
Last Activity: 20 August 2007, 1:44 AM EDT
Posts: 2
Thanks Given: 0
Thanked 0 Times in 0 Posts
cut
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.
02331814579359.6500000004
0348991976138.6767000001
04201280145145.4400000002
08654312609500.3800000002
09155934830963.3300000018
10166784506.0399999991
11884517456.5800000032
12108694361.4000000014
1324377035481.8500000004
15962912770.06
170101083.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