06-08-2012
The second one is just perfect
I seem to have badly formatted input !~ /City: / also seems to do the trick.
Thanks a lot.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have problem in including date in side awk,
my code as follows:
performace=performace.txt
reporttime=`date`
cat $performace | grep "testString" | awk '{ if ($3 > 20 ){print $reporttime $1 $2 $3}}' >> $rpt
$reporttime is not reflecting properly in my report file($rpt)?
how to... (3 Replies)
Discussion started by: redlotus72
3 Replies
2. Shell Programming and Scripting
Hi,
I have a sql file that runs something like this
vi Test.sql
REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM PUBLIC;
REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM DEMO_READ;
REVOKE SELECT ON DEMO_USER.DEMO_NOMINEE_TEST FROM DEMO_READ;
REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM... (3 Replies)
Discussion started by: rajan_san
3 Replies
3. Shell Programming and Scripting
Hello,
I was using a shell script for sending contents of a text file(email.report) to different users.
I was using the below command in my script to send email...
cat email.report | /usr/bin/mailx -s $REQ_SUBJECT -h 5 abc@xyz.com
It was working fine all these days but now all of a sudden it... (18 Replies)
Discussion started by: smarty86
18 Replies
4. Shell Programming and Scripting
Hello,
let's start by giving you guys a few examples of the text:
"READ /TEXT123/ABC123"
"READ /TEXT123/ABC123/"
"READ TEXT123/ABC123"
"READ TEXT123/ABC123/"
"READ TEXT123/TEXT456/ABC123"
"READ /TEXT123/TEXT456/ABC123"
"READ /TEXT123/TEXT456/ABC123/"
TEXT and ABC can be and I... (5 Replies)
Discussion started by: TehOne
5 Replies
5. Shell Programming and Scripting
Hi,
I have a input file with many records as below:
1J4RR4GG0BC508200 68646 1 N M
i want my output file to be like with columns included dgismdh and timestamp :
Example:
1J4RR4GG0BC508200 68646 1 N M dgismdh 2012-02-21 07:22:25.98591
How to do it.can we do using awk?
Pls help. (6 Replies)
Discussion started by: sonam273
6 Replies
6. Shell Programming and Scripting
Pleeeeease help..
I'm working in perl
i have a system function to check whether a file is readable for others or not.
i just want to print a text in that command
my command is :
system ("ls -la $filename | awk '\$1~ /^-......r../ {print \$9}'");
i know for displaying text in awk... (6 Replies)
Discussion started by: shubhamsachdeva
6 Replies
7. Shell Programming and Scripting
HI all,
I have data in a file that looks like this:
1 HOW _ NNP NNP _ 3 nn _ _
2 DRUGS _ NNP NNP _ 3 nn _ _
3 ACT _ NNP NNP _ 0 null _ _
4 : _ ... (3 Replies)
Discussion started by: owwow14
3 Replies
8. Shell Programming and Scripting
Hi guys I am trying to figure out how to match a pattern with a regex up to a full blank line. I will show you what I mean with this example:
example A
movie name: ted
movie name: TMNT
movie name: Jinxed
example B
movie names:
Gravity
Faster
Turbo
song titles:
dont
hello
problem (8 Replies)
Discussion started by: acoding
8 Replies
9. Shell Programming and Scripting
I am running an awk to verify all the memory settings for tomcat, and need to include path or directory in output ....
I am running:
awk '{ print $3 }' /opt/dir1/dir2/*/tomcat/bin/setenv.sh
Output results:
-Xms1024m
-Xmx1536m
-Xmx1536m
-Xmx1024m
-Xms1024m
-Xms1024m
-Xms512m
-Xms1024m... (3 Replies)
Discussion started by: kgolli
3 Replies
10. Shell Programming and Scripting
I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close:
awk so far:
awk '{sub(/\|]+]++/, ""); print }' input.txt Input
chr1 955543 955763 AGRN-6|pr=2|gc=75 0 +
chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 +
chr1 970621 ... (7 Replies)
Discussion started by: cmccabe
7 Replies
LEARN ABOUT PHP
mysqli_use_result
MYSQLI_USE_RESULT(3) 1 MYSQLI_USE_RESULT(3)
mysqli::use_result - Initiate a result set retrieval
Object oriented style
SYNOPSIS
mysqli_result mysqli::use_result (void )
DESCRIPTION
Procedural style
mysqli_result mysqli_use_result (mysqli $link)
Used to initiate the retrieval of a result set from the last query executed using the mysqli_real_query(3) function on the database con-
nection.
Either this or the mysqli_store_result(3) function must be called before the results of a query can be retrieved, and one or the other
must be called to prevent the next query on that database connection from failing.
Note
The mysqli_use_result(3) function does not transfer the entire result set from the database and hence cannot be used functions such
as mysqli_data_seek(3) to move to a particular row within the set. To use this functionality, the result set must be stored using
mysqli_store_result(3). One should not use mysqli_use_result(3) if a lot of processing on the client side is performed, since this
will tie up the server and prevent other threads from updating any tables from which the data is being fetched.
RETURN VALUES
Returns an unbuffered result object or FALSE if an error occurred.
EXAMPLES
Example #1
mysqli::use_result example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */
if ($mysqli->multi_query($query)) {
do {
/* store first result set */
if ($result = $mysqli->use_result()) {
while ($row = $result->fetch_row()) {
printf("%s
", $row[0]);
}
$result->close();
}
/* print divider */
if ($mysqli->more_results()) {
printf("-----------------
");
}
} while ($mysqli->next_result());
}
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */
if (mysqli_multi_query($link, $query)) {
do {
/* store first result set */
if ($result = mysqli_use_result($link)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s
", $row[0]);
}
mysqli_free_result($result);
}
/* print divider */
if (mysqli_more_results($link)) {
printf("-----------------
");
}
} while (mysqli_next_result($link));
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
my_user@localhost
-----------------
Amersfoort
Maastricht
Dordrecht
Leiden
Haarlemmermeer
SEE ALSO
mysqli_real_query(3), mysqli_store_result(3).
PHP Documentation Group MYSQLI_USE_RESULT(3)