The awk subtraction giving exponential values.Please help resolve it
Hi friends,
I have a file list1 which has these 2 columns like
I have to put the result of col1 -col2 into another file list2 linewise.
e.g. It gives the below result if use the below code:
I don't want the exponential values
The problem with my code is that it turns the subtraction result into exponential for values greater than 6 digits. How should i modify the awk command (using some formatting features...i tried it but no success) to get the result in the format like given below
Also if i try to convert the above exponential values to integer i use some values like 2.15108e+06 becomes 2151080 instead of required 2151083.
For now i have used the below workaround , But can anyone please tell me how to modify my above awk syntax to achieve it.
I have searched this forum number of times for this ,but no success still.
Regds,
Kunwar
Last edited by Scott; 03-06-2011 at 06:20 AM..
Reason: Please use code tags.
Hi.
Is there a way to convert a value outputted as(for example):
4.14486e+06 into a regular format: 4144860
I suppose in plain english i want to move the decimal point 6 places to the right.
please??? (2 Replies)
Hi All,
I have 1 million records file. Using awk, I am counting the number of records. But as the number is huge, after crossing a number, awk is displaying it in exponential format.
At the end, I need to verify this count given by awk with expected count.
But as it is in exponential format,... (3 Replies)
AWK subtraction in multiple columns
Hi there,
Can not get the following:
input: 34523 934
9485 3847
394 3847
3456 9384
awk 'NR==1 {for (i = 1; i <= NF; i++) {n=$i; next}; {n-=$i} END {print n}' input
output: 21188 first column only,... (2 Replies)
Hi,
I have a number of large (500Mb) txt files in the following format:
8.05475136E+05 9.69428147E+05 1 14 2968.00 3419.00 59.00 59 3.4028235E+38 2 w99-100
8.05464719E+05 9.69435064E+05 1 14 2968.03 3418.50 60.00 60 3.4028235E+38 2 w99-100
8.05454301E+05 ... (4 Replies)
I have various numbers that I'm printing out from a statistical summary script. I'd like it to stop using exponential format. Of course, I can use printf with 'd' and 'f' and various parameters to specify a format, but then it has other undesirable effects, like tacking on extra 0's or truncating... (0 Replies)
FileA
F97S 83 530
K569E 531 736
output shud be
F16S
K40E
it is code
sed 's///g' FileA |awk '{print $1-$2+2}'
it will print
16
40
anything can come with this output?? (1 Reply)
I'm using the following command, but how can I avoid printing exponential value (highlighted):-
awk ' BEGIN { OFS=FS="|" } { if(NF>4) $10=int(((3.77*$11)/100 + $11)); } { print } ' infile
CR|20121022|105|GSM|N|SAN|00122|SAN|75082|6.03929e+06|5819880|5794769|25111... (7 Replies)
I am trying to speed up creating a line by line hash file from a huge file using Perl.
Here is my current (working but too slow) Bash code:
(while read line; do hash=$(echo -n $line | md5sum); echo ${hash:0:32}; done)And here is my Perl code:
perl -MDigest::MD5 -le 'foreach $line ( <STDIN> )... (3 Replies)
Hi Friends,
My input
Gene1 4.14887050399078e-49
Gene2 5.39999891278828e-10
Gene 2.22108326729483e-11
How do I change the above exponential values to normal values?
Thanks (3 Replies)
Discussion started by: jacobs.smith
3 Replies
LEARN ABOUT PHP
var_export
VAR_EXPORT(3) 1 VAR_EXPORT(3)var_export - Outputs or returns a parsable string representation of a variableSYNOPSIS
mixed var_export (mixed $expression, [bool $return = false])
DESCRIPTION var_export(3) gets structured information about the given variable. It is similar to var_dump(3) with one exception: the returned represen-
tation is valid PHP code.
PARAMETERS
o $expression
- The variable you want to export.
o $return
- If used and set to TRUE, var_export(3) will return the variable representation instead of outputting it.
RETURN VALUES
Returns the variable representation when the $return parameter is used and evaluates to TRUE. Otherwise, this function will return NULL.
NOTES
Note
When the $return parameter is used, this function uses internal output buffering so it cannot be used inside an ob_start(3) callback
function.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.1.0 | |
| | |
| | Possibility to export classes and arrays con- |
| | taining classes using the __set_state() magic |
| | method. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
var_export(3) Examples
<?php
$a = array (1, 2, array ("a", "b", "c"));
var_export($a);
?>
The above example will output:
array (
0 => 1,
1 => 2,
2 =>
array (
0 => 'a',
1 => 'b',
2 => 'c',
),
)
<?php
$b = 3.1;
$v = var_export($b, true);
echo $v;
?>
The above example will output:
3.1
Example #2
Exporting classes since PHP 5.1.0
<?php
class A { public $var; }
$a = new A;
$a->var = 5;
var_export($a);
?>
The above example will output:
A::__set_state(array(
'var' => 5,
))
Example #3
Using __set_state() (since PHP 5.1.0)
<?php
class A
{
public $var1;
public $var2;
public static function __set_state($an_array)
{
$obj = new A;
$obj->var1 = $an_array['var1'];
$obj->var2 = $an_array['var2'];
return $obj;
}
}
$a = new A;
$a->var1 = 5;
$a->var2 = 'foo';
eval('$b = ' . var_export($a, true) . ';'); // $b = A::__set_state(array(
// 'var1' => 5,
// 'var2' => 'foo',
// ));
var_dump($b);
?>
The above example will output:
object(A)#2 (2) {
["var1"]=>
int(5)
["var2"]=>
string(3) "foo"
}
NOTES
Note
Variables of type resource couldn't be exported by this function.
Note
var_export(3) does not handle circular references as it would be close to impossible to generate parsable PHP code for that. If you
want to do something with the full representation of an array or object, use serialize(3).
Warning
When var_export(3) exports objects, the leading backslash is not included in the class name of namespaced classes for maximum com-
patibility.
SEE ALSO print_r(3), serialize(3), var_dump(3).
PHP Documentation Group VAR_EXPORT(3)