I have several 'ascii' tables in a directory, some of them have numbers expressed in decimal and some others ones in floating point, as follow:
1 1 1423 1 2 1589 1 3 0.85e 5 1 4 0.89e 4 1 5 8796 ... Is there a way to convert all the value of the tables in decimal numbers? I heard that using tr editor might be useful but I can´t figure out how to operate the conversion.
The sed script gets rid of the space after the 'e', and the awk script just prints out each field (multiplying $3 by 1 to "convert" it to a non-fp decimal number):
$ sed -e 's/e /e/g' file | awk '{print $1, $2, $3 * 1}' 1 1 1423 1 2 1589 1 3 85000 1 4 8900 1 5 8796 This assumes that the floating point numbers in the file:
awk will print them as fp.It's possible to get awk to do the 's/e /e/' transformation (so sed isn't needed) but it's getting late and my brain's tired. sed | awk is easy and it works.
This will do the conversion:
awk '{print $1, $2, $3 * 10**$4}' file.csv Assuming:
If an specific format is needed, some form of printf could be used.
For example:
awk '{printf( "%s %s %g "ORS,$1,$2,$3*10**$4)}' file.csv could print this:
1 1 1423 1 2 1589 1 3 85000 1 4 8900 1 5 8796 2 8 2.589e+28 Last line added to show final format for big exponents.
{ sed 's/ /+/3' | xargs printf '%G% G% G\n'; } <in >out 1 1 1423 1 2 1589 1 3 85000 1 4 8900 1 5 8796 You'll wanna play around with the %G precision flags if the numbers get much larger than that.
Other variant with awk sprintf
awk 'NF==4{$(NF-1)=sprintf(CONVFMT, $(NF-1)$NF);NF=3}1' file 
man asciiis an ascii table, I don't really understand the question.,is commonly used instead of.in many european countries as the "decimal point" delimiter