Hi All,
After Sorting directories and files i have got following output as below, now i only want the strings common in them, so the actual output should be as below in the bottom. How do i do that?
Thanks
-adsi
File to be modified:-
Common Components for ----> AA... (4 Replies)
Hi, my dilemna is this:
example i got a file of fruit.txt which contains:
Apple 6
Apple_new 7
old_orange 9
orange 10
Is there any way for me to have an output of
Apple 13
Orange 19
using shell script: (6 Replies)
Hello,
I have a log file that has following output as below.
LAP.sun5 CC
LAP.sun5 CQ
perl.sun5 CC
perl.sun5 CQ
TSLogger.sun5 CC
TSLogger.sun5 CQ
TSLogger.sun5 KR
WAS.sun5 CC
WAS.sun5 MT
WAS.sun5 CQ
I want to output to be in the way below, i tried using awk but could not do it. ... (12 Replies)
Hi,
I have several files that look like this:
File1.txt
Data1
Data2
Data20
File2.txt
Data1
Data5
Data10
File3.txt
Data1
Data2
Data17
File4.txt (6 Replies)
We usually use the following awk code to delete of find out the replicate record.
awk -F, '{a++} END {for (i in a) if (a>=2) print i a}' file
My question is how can I print the whole record. The following code doesn't work.
awk -F, '{a++} END {for (i in a) if (a>=2) print $0}' file
... (8 Replies)
Hello,
Does anyone know an easy way to filter this type of file? I want to get everything that has score (column 2) 100.00 and get rid of duplicates (for example gi|332198263|gb|EGK18963.1| below), so I guess uniq can be used for this?
gi|3379182634|gb|EGK18561.1| 100.00... (6 Replies)
Hi All,
I have a file like this(having 2 column).
Column 1: like a,b,c....
Column 2: having numbers.
I want to segregate those numbers based on column 1.
Example:
file.
a 5
b 9
b 620
a 710
b 230
a 330
b 1910 (4 Replies)
Discussion started by: Raza Ali
4 Replies
LEARN ABOUT PHP
pdostatement.setfetchmode
PDOSTATEMENT.SETFETCHMODE(3) 1 PDOSTATEMENT.SETFETCHMODE(3)PDOStatement::setFetchMode - Set the default fetch mode for this statement
SYNOPSIS
public bool PDOStatement::setFetchMode (int $mode)
DESCRIPTION
bool PDOStatement::setFetchMode (int $PDO::FETCH_COLUMN, int $colno) bool PDOStatement::setFetchMode (int $PDO::FETCH_CLASS, string
$classname, array $ctorargs) bool PDOStatement::setFetchMode (int $PDO::FETCH_INTO, object $object)
PARAMETERS
o $mode
- The fetch mode must be one of the PDO::FETCH_* constants.
o $colno
- Column number.
o $classname
- Class name.
o $ctorargs
- Constructor arguments.
o $object
- Object.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the fetch mode
The following example demonstrates how PDOStatement.setFetchMode(3) changes the default fetch mode for a PDOStatement object.
<?php
$sql = 'SELECT name, colour, calories FROM fruit';
try {
$stmt = $dbh->query($sql);
$result = $stmt->setFetchMode(PDO::FETCH_NUM);
while ($row = $stmt->fetch()) {
print $row[0] . " " . $row[1] . " " . $row[2] . "
";
}
}
catch (PDOException $e) {
print $e->getMessage();
}
?>
The above example will output:
apple red 150
banana yellow 250
orange orange 300
kiwi brown 75
lemon yellow 25
pear green 150
watermelon pink 90
PHP Documentation Group PDOSTATEMENT.SETFETCHMODE(3)