I have to match each row in file 1 with 1st row in file 2 and print the corresponding column from file2. I am trying to use an awk script to do this. For example
cat File1
cat File2
Desired output is
cat File3
It will be really helpful if anyone can suggest how to do this in awk.
Hi,
I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines).
#################################
huge_file.txt
a
a
ab
b
##################################
small_file.txt
a 1.5
b 2.5
ab ... (4 Replies)
I have two files... file1 and file2.
Where columns 1 and 2 of file1 match columns 1 and 2 of file2 I want to create a new file that is all file1 + columns 3 and 4 of file2
:b: Many thanks if you know how to do this.... :b:
file1
31-101 106 0 92
31-101 106 29 ... (2 Replies)
Hello,
I have two files which are of the following format
File 1 which has two columns
Protein_ID Substitution
NP_997239 T53R
NP_060668 V267M
NP_058515 P856A
NP_001206 T55M
NP_006601 D371Y ... (2 Replies)
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Kindly help merging information from two files with the following data structure.
I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID
Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique.
Also would be helpful to clean up... (4 Replies)
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
LEARN ABOUT PHP
pdostatement.bindcolumn
PDOSTATEMENT.BINDCOLUMN(3) 1 PDOSTATEMENT.BINDCOLUMN(3)PDOStatement::bindColumn - Bind a column to a PHP variable
SYNOPSIS
public bool PDOStatement::bindColumn (mixed $column, mixed &$param, [int $type], [int $maxlen], [mixed $driverdata])
DESCRIPTION PDOStatement.bindColumn(3) arranges to have a particular variable bound to a given column in the result-set from a query. Each call to
PDOStatement.fetch(3) or PDOStatement.fetchAll(3) will update all the variables that are bound to columns.
Note
Since information about the columns is not always available to PDO until the statement is executed, portable applications should
call this function afterPDOStatement.execute(3).
However, to be able to bind a LOB column as a stream when using the PgSQL driver, applications should call this method before call-
ing PDOStatement.execute(3), otherwise the large object OID will be returned as an integer.
PARAMETERS
o $column
- Number of the column (1-indexed) or name of the column in the result set. If using the column name, be aware that the name
should match the case of the column, as returned by the driver.
o $param
- Name of the PHP variable to which the column will be bound.
o $type
- Data type of the parameter, specified by the PDO::PARAM_* constants.
o $maxlen
- A hint for pre-allocation.
o $driverdata
- Optional parameter(s) for the driver.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Binding result set output to PHP variables
Binding columns in the result set to PHP variables is an effective way to make the data contained in each row immediately available
to your application. The following example demonstrates how PDO allows you to bind and retrieve columns with a variety of options
and with intelligent defaults.
<?php
function readData($dbh) {
$sql = 'SELECT name, colour, calories FROM fruit';
try {
$stmt = $dbh->prepare($sql);
$stmt->execute();
/* Bind by column number */
$stmt->bindColumn(1, $name);
$stmt->bindColumn(2, $colour);
/* Bind by column name */
$stmt->bindColumn('calories', $cals);
while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
$data = $name . " " . $colour . " " . $cals . "
";
print $data;
}
}
catch (PDOException $e) {
print $e->getMessage();
}
}
readData($dbh);
?>
The above example will output:
apple red 150
banana yellow 175
kiwi green 75
orange orange 150
mango red 200
strawberry red 25
SEE ALSO PDOStatement.execute(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDOStatement.fetchColumn(3).
PHP Documentation Group PDOSTATEMENT.BINDCOLUMN(3)