[SOLVED] tried with shell scripts...

czezz · 12-27-2010, 10:14 AM

This is right if I remove "1" at the end of the line it will print only converted/counted values (Preliminary with E).
How to have all the rest part of input file ?

grail · 12-27-2010, 10:45 AM

Probably time you did a little bit of investigating yourself. Look here and you should be able to solve this.

czezz · 01-04-2011, 08:26 AM

I havent find right way to get rid of repeated Preliminary with E next to correctly counted value so I did a work around:

1. I have modified code I alrdy had to this below. This prints out each value correctly counted (with out repeated E value) but it sets each one value into a 1 columne.

Code:

nawk 'BEGIN {ORS=RS=",";}{printf "%.2f,\n", $0;}'

2. ...so the output from above need to be transpose.
On this post I got a nice way to do it: http://www.linuxquestions.org/questi...nspose-852796/

Code:

nawk '{printf "%s", $0}!(NR % 8){printf "\n"}'

Its work around but it works.
I got what I need

grail · 01-04-2011, 09:13 AM

Well now that you have had a bit of a go ... see how this goes for you:

Code:

nawk 'BEGIN{ORS=RS=",";IGNORECASE=1}/E/{split($0,arr,"E");$0=sprintf("%.2f,",arr[1]*10^arr[2]/2^100)}RT' file