Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd
hi
I have 2 file with more than 10 columns for both
1st file
2nd file
I want to match the first column of both file and if it matches, print the whole line from 1st file and append 7th column from 2nd file to it for everyline so it becomes like this
Any help would be much appreciated
Moderator's Comments:
code tags please
Last edited by jim mcnamara; 03-14-2019 at 11:05 AM..
ex:
a file has :
122323
123456456
125656879
678989965t635
234323432
b has :
this is finance no.
this is phone no
this is extn
ajkdgag
idjsidj
i want the o/p as:
122323 his is finance no.
123456456 this is phone no
123456456 ... (4 Replies)
I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this).
For example, i have a input file1.txt:
cat inputfile1.txt
218299910417
1172051195
1172070231
1172073514
1183135117
1183135118
1183135119
1281440202
... (3 Replies)
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)
Hi Experts,
I am very new to scripting and have a prb since few days and it is urgent to solve so much appreciated if u help me.
i have 2 files
file1.txt
9647810043118
9647810043126
9647810043155
9647810043161
9647810043166
9647810043185
9647810043200
9647810043203
9647810043250... (22 Replies)
Hi friends,
My file is like:
Second file is :
I need to print the rows present in file one, but in order present in second file....I used
while read gh;do
awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile
done < secondfile
but the output I am... (14 Replies)
Hi everyone. I need to change a script (ksh) so that it will grep on the 1st 2 letters in the second column of a 5 column file such as this one:
192.168.1.1 CAXY0_123 10ABFL000001 # Comment
192.168.1.2 CAYZ0_123 10ABTX000002 # Comment
192.168.2.1 FLXY0_123 11ABCA000001 ... (4 Replies)
Hi all,
I have a log file say Test.log that gets updated continuously and it has data in pipe separated format. A sample log file would look like:
<date1>|<data1>|<url1>|<result1>
<date2>|<data2>|<url2>|<result2>
<date3>|<data3>|<url3>|<result3>
<date4>|<data4>|<url4>|<result4>
What I... (3 Replies)
I have file that looks like this,
DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151
DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797
DIP-19588N|refseq:NP_731165 ... (2 Replies)
I have a file with class c IP addresses that I need to match to a column and print the matching lines of another file.
I started playing with grep -if file01.out file02.out but I am stuck as to how to match it to a column and print the matching lines;
cat file01.out
10.150.140... (5 Replies)
Discussion started by: lewk
5 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)