select data conversion based on value range

Question

I have a text file with 3 columns of data. However at random times in the various files there is a change in the in the observed unit from ppn to ppb resulting in the need of a conversion factor and multiplication by 1000.

actual data                        needed data look
20101001,01:00,0.3                 20101001,01:00,0.3,300.000
20110103,10:00,212.67              20110103,10:00,212.670,212.670

I have a awk command to print all original and add a fourth column with the conversion.

The only issue is it prints everything everything in the third column by 1000 and print to the fourth column. The command is below....

awk -F ',' '{printf "%s %s %.3f %.3f\n", $1,$2,$3,$3*1000}' temp7.tmp > County001-CO-0012.out

How can I can only values between 2 and -1 in column #3 only get multiplied by 1000 and other wise print the orignal value of column 3 in column 4?

glenn jackman · Accepted Answer · 2021-04-16 20:28:27Z

2

You can do this in the awk code:

{
    # if $3 is between -1 and 2, multiply by 1000
    converted = $3 * (-1 <= $3 && $3 <= 2 ? 1000 : 1)
    printf "%s %s %.3f %.3f\n", $1, $2, $3, converted
}

answered Apr 16, 2021 at 20:28

glenn jackman

88.5k16 gold badges124 silver badges179 bronze badges

Add a comment |

Stack Exchange Network

select data conversion based on value range

1 Answer 1

You must log in to answer this question.

Hot Network Questions

select data conversion based on value range

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions