03-28-2011
grep across multiple lines
How do you grep 'select * from table_name' string from a script if the select * and from table_name are on 2 different lines ? like
select *
from table_name
Any help would be greatly appreciated !!!
Thanks
RDR
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I 'm trying to grep 2 fieldds on 2 differnt lines. Like this:
psit > file
egrep -e '(NS|ES)' $file. Not working. If this succeeds then run next cmd else exit. Pls Help
Gundu (13 Replies)
Discussion started by: gundu
13 Replies
2. Shell Programming and Scripting
Hey guys:
I've been meaning to post this question for awhile...it is regarding grep. Let's say for example that the following entry is in logxx:
Wed Feb 2 07:44:11 <vsm> 91030 Line 5 Severity 1 Vps 6
Call Answered - DN:8753101 CLID:5164665761 PI:83
If I do a grep 91030... (27 Replies)
Discussion started by: cdunavent
27 Replies
3. Shell Programming and Scripting
Hi.
I have this format on a textfile:
VG Name /dev/vg00
PV Name /dev/dsk/c16t0d0
PV Name /dev/dsk/c18t0d0
PV Name /dev/dsk/c16t4d0
VG Name /dev/vg01
PV Name ... (6 Replies)
Discussion started by: jOOc
6 Replies
4. UNIX for Dummies Questions & Answers
I want to search files (basically .cc files) in /xx folder and subfolders.
Those files (*.cc files) must contain #include "header.h" AND x() function.
I am writing it another way to make it clear,
I wanna list of *.cc files that have 'header.h' & 'x()'. They must have two strings, header.h... (2 Replies)
Discussion started by: ritikaSharma
2 Replies
5. UNIX for Dummies Questions & Answers
hi
i have kind of below text in a file.
I want to get a complete paragraph starting with START and ending with before another START) which has a particular string say XYZ or ABC
START XYZ hshjghkjh 45 ljkfd
fldjlj d jldf
START 3493u ABC 454
4545454
4545454 45454
4545454
START ...... (3 Replies)
Discussion started by: reldb
3 Replies
6. UNIX for Dummies Questions & Answers
I want to grep multiple lines from a text file. I want to grep all lines containing X,Y and NA in a single command. How do I go about doing that?
This is what my text files look like:
rs1983866 0.0983 10 100016313
rs1983865 0.5994 X 100016339
rs1983864 0.3272 11 100017453
rs7077266... (2 Replies)
Discussion started by: evelibertine
2 Replies
7. Shell Programming and Scripting
Hello all,
I have been struggling to get grep work to my requirements. Basically I have to filter out patterns spread across multiple lines over hundreds of .gz files in a folder. And the output needs to be piped to a file.
Here is the example:
folder name: logs
files in this folder:... (4 Replies)
Discussion started by: mandhan
4 Replies
8. Shell Programming and Scripting
Hello:
I am trying to use grep in cygwin to do the following, however I am unable to get the output in the desired format. Please see and let me know how to solve this
Input log file
20140403 07:29:26 IN:CTRL=:TYP=TYP1:DCN=DCN1:DATA=
20140403 07:25:26 IN:CTRL=:TYP=TYP1:DCN=DCN2:DATA=... (4 Replies)
Discussion started by: wincrazy
4 Replies
9. Shell Programming and Scripting
Hi guys,
I have a log file that generates multiple logs about a query.
<query time='2016-04-13 13:01:50.825'>
<PagingRequestHandler>
<Before>brand:vmu</Before>
<After>brand:vmu</After>
</PagingRequestHandler>
<GroupDeviceFilterHandler>
<Before>brand:vmu</Before>
... (3 Replies)
Discussion started by: Junaid Subhani
3 Replies
10. Shell Programming and Scripting
Hi,
I'm working on a shell script that reports service status on a database server.
There are some services that are in disabled status that the script should ignore and only check the services that are in Enabled status.
I output the service configuration to a file and use that information to... (5 Replies)
Discussion started by: senthil3d
5 Replies
LEARN ABOUT PHP
pg_convert
PG_CONVERT(3) PG_CONVERT(3)
pg_convert - Convert associative array values into suitable for SQL statement
SYNOPSIS
array pg_convert (resource $connection, string $table_name, array $assoc_array, [int $options])
DESCRIPTION
pg_convert(3) checks and converts the values in $assoc_array into suitable values for use in an SQL statement. Precondition for pg_con-
vert(3) is the existence of a table $table_name which has at least as many columns as $assoc_array has elements. The fieldnames in $ta-
ble_name must match the indices in $assoc_array and the corresponding datatypes must be compatible. Returns an array with the converted
values on success, FALSE otherwise.
Note
If there are boolean fields in $table_name don't use the constant TRUE in $assoc_array. It will be converted to the string 'TRUE'
which is no valid entry for boolean fields in PostgreSQL. Use one of t, true, 1, y, yes instead.
Warning
This function is EXPERIMENTAL. The behaviour of this function, its name, and surrounding documentation may change without notice in
a future release of PHP. This function should be used at your own risk.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
o $table_name
- Name of the table against which to convert types.
o $assoc_array
- Data to be converted.
o $options
- Any number of PGSQL_CONV_IGNORE_DEFAULT, PGSQL_CONV_FORCE_NULL or PGSQL_CONV_IGNORE_NOT_NULL, combined.
RETURN VALUES
An array of converted values, or FALSE on error.
EXAMPLES
Example #1
pg_convert(3) example
<?php
$dbconn = pg_connect('dbname=foo');
$tmp = array(
'author' => 'Joe Thackery',
'year' => 2005,
'title' => 'My Life, by Joe Thackery'
);
$vals = pg_convert($dbconn, 'authors', $tmp);
?>
SEE ALSO
pg_meta_data(3).
PHP Documentation Group PG_CONVERT(3)