Hi,
I need to multiply 3rd column (comma seperated) of entire file by a value say 2.2.
Suppose the file is:
C,Gas $ YTD(TRI),15512.36,01/01/2010
New file should be (3rd column value multiplied by 2.2):
C,Gas $ YTD(TRI),34127.192,01/01/2010 (5 Replies)
So I have this input
1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI
1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI
1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI
1 10583 rs58108140 G A ... (3 Replies)
I have a file that looks like this
452 025_E3
8 025_E3
82 025_F5
135 025_F5
5 025_F5
23 025_G2
38 025_G2
71 025_G2
9 026_A12
81 026_A12
10 026_A12
some of the elements in column2 are repeated.
I want an output file that will extract the... (1 Reply)
Hi All,
I have following html code
<TR><TD>9</TD><TD>AR_TVR_TBS </TD><TD>85000</TD><TD>39938</TD><TD>54212</TD><TD>46</TD></TR>
<TR><TD>10</TD><TD>ASCV_SMY_TBS </TD><TD>69880</TD><TD>33316</TD><TD>45698</TD><TD>47</TD></TR>
<TR><TD>11</TD><TD>ARC_TBS ... (9 Replies)
Hi experts,
I want to multiply certain columns to variable,
data :
1 2 3 4 5 6 7 8 9
result with var = 2 for column 3,6,9 ... (every columns which can be divided to 3):
1 2 6 4 5 12 7 8 18
I have tried :
awk 'BEGIN{FS=OFS=" "}{print $1,$2,$3*a,$4,$5,$6*a,$7,$8,$9*2 }' a=2 file.txt
but how... (6 Replies)
Hi all,
I have a quick question:
I have a 4 column tab-separated file.
I want to count the number of times each unique value in column 2 appears and add that number in a 5th column.
I have the following input file:
waterline-n below-sheath-v 14.8097 A
dock-n below-sheath-v ... (4 Replies)
HI, I have a 3-column tab separated column (approx 1GB) in which I would like to count and output the frequency of all of the common elements in the 1st column.
For instance:
If my input was the following:
dot is-big 2
dot is-round 3
dot is-gray 4
cat is-big 3
hot in-summer 5
My... (4 Replies)
Hi all
I have a great challenge that I am not able to resolve.
Briefly, I have a file like this:
ID_1 chr1 100 -
ID_2 chr2 300 +
and another file like this:
name_1 chr1 150 no -
name_2 chr1 250 yes -
name_3 chr2 350 yes +
name_4 chr2 280 yes +
Well, for each entry in file1 I would... (2 Replies)
So I need to Write an array processing program using a Linux shell programming language to perform the following.
Load array X of 20 numbers from an input file X.
Load array Y of 20 numbers from an input file Y.
Compute array Z by multiply Xi * Yi then compute the square-root of this... (2 Replies)
Discussion started by: sarapham409
2 Replies
LEARN ABOUT PHP
fbsql_fetch_field
FBSQL_FETCH_FIELD(3) 1 FBSQL_FETCH_FIELD(3)fbsql_fetch_field - Get column information from a result and return as an objectSYNOPSIS
object fbsql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
Used in order to obtain information about fields in a certain query result.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $field_offset
- The numerical offset of the field. The field index starts at 0. If not specified, the next field that wasn't yet retrieved by
fbsql_fetch_field(3) is retrieved.
RETURN VALUES
Returns an object containing field information, or FALSE on errors.
The properties of the object are:
o name - column name
o table - name of the table the column belongs to
o max_length - maximum length of the column
o not_null - 1 if the column cannot be
NULL
o type - the type of the column
EXAMPLES
Example #1
fbsql_fetch_field(3) example
<?php
fbsql_connect($host, $user, $password)
or die("Could not connect");
$result = fbsql_db_query("database", "select * from table")
or die("Query failed");
# get column metadata
$i = 0;
while ($i < fbsql_num_fields($result)) {
echo "Information for column $i:<br />
";
$meta = fbsql_fetch_field($result);
if (!$meta) {
echo "No information available<br />
";
}
echo "<pre>
max_length: $meta->max_length
name: $meta->name
not_null: $meta->not_null
table: $meta->table
type: $meta->type
</pre>";
$i++;
}
fbsql_free_result($result);
?>
SEE ALSO fbsql_field_seek(3).
PHP Documentation Group FBSQL_FETCH_FIELD(3)