Hello All,
I have a string "CP_STATUS OSSRC_R6_0_Shipment_R1H_CU AOM_901046 R1H_LLSV1_2008031", and I just want to extract LLSV1, but I dont get the expected result when using the sed command below.
# echo "CP_STATUS OSSRC_R6_0_Shipment_R1H_CU AOM_901046 R1H_LLSV1_2008031" | awk '{print... (4 Replies)
Hi
i want to search two pattern on same line and replace onther pattern..
INPut file
aaaa bbbbb nnnnnn ttttt
cccc bbbbb nnnnnn ppppp
dddd ccccc nnnnnn ttttt
ffff bbbbb oooooo ttttt
now i want replace this matrix like.. i want search for "bbbbb","nnnnnn" and search and replace for... (4 Replies)
Hi,
i want to remove a certain pattern when i type pwd.
pwd will look like this:
..../....../....../Pat_logs/..../....../...../......
the dotted lines are just random directory names,
i want it to remove the "Pat_logs/...../....../....../" part
so for example:
... (8 Replies)
I need this.
aaa
OOOOO
bbb
ccc
OOOOO
ddd
fff
ggg
OOOOO
iii
OOOOO
I need all OOOOO replaced with PPPPP, but only change after the pattern ggg. So the first two OOOOO should not be changed.
OUTPUT should be :-
aaa (2 Replies)
I have a pattern
username:x:32005:32006::/usr/local/user:/bin/bash
I need to match the line containing username and replace /bin/bash with /usr/local/my/bin/noshell
So it becomes
username:x:32005:32006::/usr/local/user:/usr/local/my/bin/noshell (7 Replies)
Hi,
I have a requirement where I need to replace a string in a line and this line will be identified by search criteria on previous line:
E.g.:
I have an xml file and Contents as below:
<Root>
<NameValue>
<name>Global/Text/Data</name>
<value>This is valid... (14 Replies)
Hi, I am a rookie of Linux.
I have a problem on how can I replace a certain pattern in Linux with nothing. Can anyone help me?:(
sample.txt:
<binding>App189
ABC SampleMachine1 ABC
XXX
YYY
ZZZ
</binding>
<binding>App190
ABC SampleMachine2 ABC
XXX
YYY
ZZZ
</binding>
<binding>App191... (3 Replies)
Hi,
Need help to extract a pattern using sed or cut or any other means.
Input
'name1',1234567890
'name2',2222222222
'name3',3333333333
Expected output
name1,1234567890
name2,2222222222
name3,3333333333 (3 Replies)
Hi experts, I'm looking for a unix solution to replacing "NA" within a matrix with the mean of the column:
$cat file
ID a b c d
day 10 5 100 50
cat 20 6 200 50
dog NA 8 NA 50
car 15 NA NA ... (3 Replies)
Not able to paste my content. Please see the attachment :-( (2 Replies)
Discussion started by: vivek d r
2 Replies
LEARN ABOUT PHP
pg_select
PG_SELECT(3)PG_SELECT(3)pg_select - Select recordsSYNOPSIS
mixed pg_select (resource $connection, string $table_name, array $assoc_array, [int $options = PGSQL_DML_EXEC])
DESCRIPTION pg_select(3) selects records specified by assoc_array which has field=>value. For a successful query, it returns an array containing all
records and fields that match the condition specified by assoc_array.
If options is specified, pg_convert(3) is applied to assoc_array with the specified flags.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
o $table_name
- Name of the table from which to select rows.
o $assoc_array
- An array whose keys are field names in the table $table_name, and whose values are the conditions that a row must meet to be
retrieved.
o $options
- Any number of PGSQL_CONV_FORCE_NULL, PGSQL_DML_NO_CONV, PGSQL_DML_ESCAPE, PGSQL_DML_EXEC, PGSQL_DML_ASYNC or PGSQL_DML_STRING
combined. If PGSQL_DML_STRING is part of the $options then query string is returned. When PGSQL_DML_NO_CONV or PGSQL_DML_ESCAPE is
set, it does not call pg_convert(3) internally.
RETURN VALUES
Returns TRUE on success or FALSE on failure. Returns string if PGSQL_DML_STRING is passed via $options.
EXAMPLES
Example #1
pg_select(3) example
<?php
$db = pg_connect('dbname=foo');
// This is safe, since $_POST is converted automatically
$rec = pg_select($db, 'post_log', $_POST);
if ($rec) {
echo "Records selected
";
var_dump($rec);
} else {
echo "User must have sent wrong inputs
";
}
?>
CHANGELOG
+-------------+---------------------------------------------------+
| Version | |
| | |
| | Description |
| | |
+-------------+---------------------------------------------------+
| 5.6.0 | |
| | |
| | No longer experimental. Added PGSQL_DML_ESCAPE |
| | constant, TRUE/ FALSE and NULL data type support. |
| | |
|5.5.3/5.4.19 | |
| | |
| | Direct SQL injection to $table_name and Indirect |
| | SQL injection to identifiers are fixed. |
| | |
+-------------+---------------------------------------------------+
SEE ALSO pg_convert(3).
PHP Documentation Group PG_SELECT(3)