02-22-2011
How to grep the exact name
Yes, I'm doing that to validate the results. However, the problem is that I can't figure out the exact grep statement to use that will work correctly when it encounters America and Latin America. I listed the various grep examples I tried to use and only one of them works when it encounters Latin America but the same grep statement does not work when it encounters America. The remaining grep examples all work correctly when they encounter America but do not work when they encounter Latin America.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I'm trying to use grep to search for a specific string. Given the following strings:
.A BAGM4 0101 Z DH1300/PPD T/SF T/SD 10
.A CLUM4 0101 Z DH1300/PP T/SF T/SD 9
.A MQT 0101 Z DH1200/PPK T/SFK 2.0/SD 15
I only want to get the string that contains PPD. If I do the command:
grep PPD... (9 Replies)
Discussion started by: wxornot
9 Replies
2. Shell Programming and Scripting
Hi All
Here is one o/p from a program I have ...
Can someone tell me the way so that I get only the output by the user "li" not the other users which have "li" in the name.
Surely I dont like the idea
Thanks a lot to all in advance
C Saha (3 Replies)
Discussion started by: csaha
3 Replies
3. UNIX for Advanced & Expert Users
hey.....
i do have text where the contents are like as follows,
FILE_TYPE_NUM_01=FILE_TYPE=01|FILE_DESC=Periodic|FILE_SCHDL_TYPE=Daily|FILE_SCHDL=|FILE_SCHDL_TIME=9:00am|RESULTS=B
FILE_TYPE_NUM_02=FILE_TYPE=02|FILE_DESC=NCTO|FILE_SCHDL_TYPE=Daily|FILE_SCHDL=|FILE_SCHDL_TIME=9:00am|RESULTS=M... (2 Replies)
Discussion started by: manas_ranjan
2 Replies
4. Shell Programming and Scripting
Hi there,
I've search this forum and find this problem could have been solved by,
grep -ho "num=*" input_data
The input_data is,
1\11\num1=100\num2=200\newnum1=220\\@
however, what I have got is ,
num1=100
num1=220
how to get the exact string, (4 Replies)
Discussion started by: liuzhencc
4 Replies
5. Solaris
Hi
This time I'm trying to grep for an exact match
e.g
cat.dog.horse.cow.bird.pig
horse.dog.pig
pig.cat.horse.dog
horse
dog
dog
pig.dog
pig.dog.bird
how do I grep for dog only so that a wc -l would result 2 in above case.
Thanks in advance
---------- Post updated at 06:33 AM... (4 Replies)
Discussion started by: rob171171
4 Replies
6. UNIX for Dummies Questions & Answers
FILE:
#test file#
server1 10.1.1.1
server2 10.1.1.2
server2-prv 10.1.1.3
grep -w "server2" {filename}
Returns:
server2 10.1.1.2
server2-prv 10.1.1.3
How would you just get it to return just the exact match line?:
server2 10.1.1.2
Thanks! (4 Replies)
Discussion started by: trimike
4 Replies
7. Shell Programming and Scripting
QUESTION1:
How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed.
Contents of car.txt
CAR1_KEY0
CAR1_KEY1
CAR2_KEY0
CAR2_KEY1
CAR1_KEY10
CURRENT COMMAND LINE: WHERE VARIABLE CAR_NUMBER=1 AND KEY_NUMBER=1
grep... (1 Reply)
Discussion started by: thibodc
1 Replies
8. Shell Programming and Scripting
Hi,
x=GATE
ps -ef|grep pmon
grid 552 1 0 Aug08 ? 00:00:51 asm_pmon_+ASM1
oracle 4314 1 0 Aug08 ? 00:04:08 ora_pmon_GATE1
oracle 5018 1351 0 10:14 pts/1 00:00:00 grep pmon
oracle 7329 1 0 Aug08 ? 00:02:19 ora_pmon_NRID1
ps... (3 Replies)
Discussion started by: rcc50886
3 Replies
9. UNIX for Dummies Questions & Answers
Hello All,
I have a file all_info.txt
Date Owner Filename
03/25/2014 mycomp\royale myfile_ goodfile_sec_20140324_c.zip
03/25/2014 mycomp\royale myfile_goodfile_sec_20140324_c.cpt
03/25/2014 mycomp\royale1 ... (9 Replies)
Discussion started by: kumar30213
9 Replies
10. Shell Programming and Scripting
Hello!
I have 2 files named tacs.tmp and tacDB.txt
tacs.tmp looks like this
0
10235647
102700
106800
107200
1105700
tacDB.txt looks like this
100100,Mitsubishi,G410,Handheld,,0,0,0
100200,Siemens,A53,Handheld,,0,0,0
100300,Sony Ericsson,TBD (AAB-1880030-BV),Handheld,,0,0,0... (2 Replies)
Discussion started by: Cludgie
2 Replies
LEARN ABOUT PHP
mysqli_stmt.get_result
MYSQLI_STMT.GET_RESULT(3) 1 MYSQLI_STMT.GET_RESULT(3)
mysqli_stmt::get_result - Gets a result set from a prepared statement
Object oriented style
SYNOPSIS
mysqli_result mysqli_stmt::get_result (void )
DESCRIPTION
Procedural style
mysqli_result mysqli_stmt_get_result (mysqli_stmt $stmt)
Call to return a result set from a prepared statement query.
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
Returns a resultset or FALSE on failure.
MYSQL NATIVE DRIVER ONLY
Available only with mysqlnd.
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("127.0.0.1", "user", "password", "world");
if($mysqli->connect_error)
{
die("$mysqli->connect_errno: $mysqli->connect_error");
}
$query = "SELECT Name, Population, Continent FROM Country WHERE Continent=? ORDER BY Name LIMIT 1";
$stmt = $mysqli->stmt_init();
if(!$stmt->prepare($query))
{
print "Failed to prepare statement
";
}
else
{
$stmt->bind_param("s", $continent);
$continent_array = array('Europe','Africa','Asia','North America');
foreach($continent_array as $continent)
{
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_array(MYSQLI_NUM))
{
foreach ($row as $r)
{
print "$r ";
}
print "
";
}
}
}
$stmt->close();
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("127.0.0.1", "user", "password", "world");
if (!$link)
{
$error = mysqli_connect_error();
$errno = mysqli_connect_errno();
print "$errno: $error
";
exit();
}
$query = "SELECT Name, Population, Continent FROM Country WHERE Continent=? ORDER BY Name LIMIT 1";
$stmt = mysqli_stmt_init($link);
if(!mysqli_stmt_prepare($stmt, $query))
{
print "Failed to prepare statement
";
}
else
{
mysqli_stmt_bind_param($stmt, "s", $continent);
$continent_array = array('Europe','Africa','Asia','North America');
foreach($continent_array as $continent)
{
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM))
{
foreach ($row as $r)
{
print "$r ";
}
print "
";
}
}
}
mysqli_stmt_close($stmt);
mysqli_close($link);
?>
The above examples will output:
Albania 3401200 Europe
Algeria 31471000 Africa
Afghanistan 22720000 Asia
Anguilla 8000 North America
SEE ALSO
mysqli_prepare(3), mysqli_stmt_result_metadata(3), mysqli_stmt_fetch(3), mysqli_fetch_array(3), mysqli_stmt_store_result(3).
PHP Documentation Group MYSQLI_STMT.GET_RESULT(3)