I have a file which contains these data:

1. C13 C 0.4797 0.5303 0.5447 -17.003
2. C14 C 0.4518 0.5232 0.5860 -16.271
3. C15 C 0.4667 0.4839 0.6154 -16.713
4. H1 H 0.4607 0.5484 0.6572 -16.795
I want to print column 3 as it is and multiply columns 4, 5, 6, with certain numbers and want to get output for column 4, 5, and 6 up to 6 decimal places. How can I do that?
I am able to multiply column 4, 5, 6 but not able to print column 3 using a command:

:%!awk '{printf "\%4.6f \%4.6f \%4.6f\n", $4*30, $5*30, $6*30}'
but not able to print column 3 alongwith those columns.

awk '{print $3}'

this will only print column 3. how to print other column after multiplication with numbers alongwith column 3?

awk '{print $3 $0}'

or something similar?

1 members found this post helpful.

The awk documentation describes how to define a string field in printf - trivial compared to floating point I would think.

1 members found this post helpful.

how to modify this command:
:%!awk '{printf "\%4.6f \%4.6f \%4.6f\n", $4*30, $5*30, $6*30}'

to print column 3 with this,so that it will give output like this:
C 5.5555 6.9999 7.8888
C 4.5555 6.5525 6.6666

I still do not understand what do you need, would be better to show us an example. But you only need to modify the printf command to include what do you need.

I got the solution, as per your suggestion I modified the command like this......It worked. Thanks everyone.

:%! awk '{printf "\%s \%4.6f \%4.6f \%4.6f\n", $3, $4*30, $5*30, $6*30}'

you are welcome
glad to help you