Could you please go through following and let me know if this is helpful for you.
Code:
awk 'FNR==NR{ #### FNR==NR condition will be TRUE when first file named decimal.csv is being read.
A[++i]=$0; #### When above condition is TRUE then create an array named A with index of variable i whose index is increasing every occurance whenever above condition is TRUE, so means till first file is being read completly.
next #### skipping all other statements now by using next keyword.
}
{
for(j=1;j<=i;j++){ #### starting for loop now which will start only when second file will be read and wen first file will be completly read then we will get a final valur of variable i so running the loop from j=1 to till i's value.
split(A[j], array,","); #### splitting the value of array A whose delimiter is comma(,). This array is having the values of decimal.csv files, which by splitting into array I wil use it later in code.
if(length($array[1])==array[2]){ #### Now I am comparing the value of field $array[1] which is field mentioned in decimal.csv and value is in file Input_file with length of field provided in decimal.csv file if they are equal then do following actions.
$array[1]=substr($array[1],1,array[3]) "." substr($array[1],array[3]+1); #### Here I am RE-FORMING the field let's say 2nd and 5th(as per your decimal.csv) file by using substr utility of awk. which works on substr(LINE,starting point, ending point) etc.
}
else{ #### In case length of field is NOT equal to length provided in decimal.csv file then do following actions.
q="-" substr($array[1],1,array[2]);$array[1]=substr(q,1,array[3]+1) "." substr(q,array[3]+2);}}; #### creating a variable named q whose value I am constructing by field values by file Input_file, more important placing dot(.) here as per requirement in between field's values.
print #### finally printing the line, not here it will print the new formatted values of fields which we have done in above steps.
}
' decimal.csv FS="|" OFS="|" Input_file #### mentioning first file named decimal.csv then Field separator as | and Output field separator as | for Input_file here.
Hi All,
Here is my original string: 192.168.2.1.8088. The target string I want: 192.168.2.1, how can I use awk or sed or other command to get rid of .8088 in the string?
Thanks,
Ray (9 Replies)
Hi
I am executing below command to do summation on 46th coloumn.
cat File1| awk -F"|" '{p += $46} END { printf"Column Name | SUM | " p}'
I am getting output as
Column Name | SUM | 1.01139e+10
Here I want output in Proper decimal format. Can someone tell me what change is required for same? (1 Reply)
Hi Experts,
Quick quesion:
I want to sort this in the file , but not working, when using # sort file name
305.932
456.470
456.469
456.468
456.467
172.089
456.467
456.466
456.465
111.573
111.578
111.572
111.572
87.175
87.174
75.898 (4 Replies)
i am having a varialbe a , which is input to my file
i want to multiply this input with value .43, and assign it to variable b.
i tried it as below:
#!/bin/sh
a=$1
b=`expr $1\*0.43`
echo b=$b
error : expr: non-integer argument
Please tell me , how to do this.
Thanks (10 Replies)
Hi All,
I would like to set decimal point to 16 in the following bash script but it has syntax error at }:
awk '{printf"%.16e", (a<500,a++,$1/(a*1.1212121212121229e-02))}' input.dat >output.datHow may I set it in the correct way please? Thank you very much! (6 Replies)
Dear all,
I have a txt file with only one column which contains p values. My data looks like this:
5.04726976606584e-190
2.94065711152402e-189
2.94065711152402e-189
9.19932135717279e-176
1.09472516659859e-170
1.24974648916809e-170
0.1223974648916
0.9874974648916
...
what I want... (2 Replies)
Hi All,
I have problem in the middle of implementing to users, whereby the complaint is all about the decimal place which is too long. I need two decimal places only, but the outcome from command is always fixed to 6.
See the sample :
before:
Sort Total
Site Sort SortName Parts ... (3 Replies)
Dear all,
I have a data test.txt as below.
X22.30799720_T cg03868770 -0.5645412582127 2.4084685750406e-175
X22.30781182_A cg03868770 -0.5620426397492 3.5818034129169e-172
X22.30780724_C cg03868770 -0.5616890165605 2.9765569717858e-168
what I want is:
X22.30799720_T cg03868770... (3 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Is there a grep commands for numbers w/decimal points
Display lines for students with GPA above 3.69 but less... (3 Replies)
Discussion started by: jetoutant
3 Replies
LEARN ABOUT PHP
variant_and
VARIANT_AND(3) 1 VARIANT_AND(3)variant_and - Performs a bitwise AND operation between two variantsSYNOPSIS
mixed variant_and (mixed $left, mixed $right)
DESCRIPTION
Performs a bitwise AND operation. Note that this is slightly different from a regular AND operation.
PARAMETERS
o $left
- The left operand.
o $right
- The right operand.
Note
As with all the variant arithmetic functions, the parameters for this function can be either a PHP native type (integer, string,
floating point, boolean or NULL), or an instance of a COM, VARIANT or DOTNET class. PHP native types will be converted to variants
using the same rules as found in the constructor for the "VARIANT" class. COM and DOTNET objects will have the value of their
default property taken and used as the variant value.
The variant arithmetic functions are wrappers around the similarly named functions in the COM library; for more information on
these functions, consult the MSDN library. The PHP functions are named slightly differently; for example variant_add(3) in PHP cor-
responds to VarAdd() in the MSDN documentation.
RETURN VALUES
Variant AND Rules
+------------+--------------------+---+
|If $left is | | |
| | | |
| | If $right is | |
| | | |
| | then the result is | |
| | | |
+------------+--------------------+---+
| | | |
| TRUE | | |
| | | |
| | | |
| | TRUE | |
| | | |
| | | |
| | TRUE | |
| | | |
| | | |
| TRUE | | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| TRUE | | |
| | | |
| | | |
| | NULL | |
| | | |
| | | |
| | NULL | |
| | | |
| | | |
| FALSE | | |
| | | |
| | | |
| | TRUE | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| FALSE | | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| FALSE | | |
| | | |
| | | |
| | NULL | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| NULL | | |
| | | |
| | | |
| | TRUE | |
| | | |
| | | |
| | NULL | |
| | | |
| | | |
| NULL | | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| | FALSE | |
| | | |
| | | |
| NULL | | |
| | | |
| | | |
| | NULL | |
| | | |
| | | |
| | NULL | |
| | | |
+------------+--------------------+---+
SEE ALSO variant_or(3).
PHP Documentation Group VARIANT_AND(3)