05-20-2009
how about 'awk' or 'gawk'?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
If I am not sure of how many fields a string has, say
STR=/homt/root/dir1/dir2/../dirn
how to use "cut -d/ -f" to get dirn ? (3 Replies)
Discussion started by: meili100
3 Replies
2. Shell Programming and Scripting
Hi guys, last cry for help for today. I appreciate the help so far.
ok so I have a program that dumps a path into my script as a variable ($1)
This path is an example
/home/xbmc/sab_downloads/video/tv/grey's anatomy/season 3
So in order to search thetvdb.com for a show, I need to extract... (6 Replies)
Discussion started by: tret
6 Replies
3. Shell Programming and Scripting
Guys,
I have a line like this: 109;201;1099010
and as you see that first field 109 and the last field starts with 109. I need to cut the rest in the last field after 109 which is 9010
How to do it? (2 Replies)
Discussion started by: sfaqih
2 Replies
4. Shell Programming and Scripting
Hello,
In a shell script I am writing I execute this command:
uniq -c names1.tmp > names2.tmp
In names2.tmp I get these results:
4 user
2 username
1 users
1 veriano
1 victoria
I need to isolate the names in this file and put it in another file. However it seems that the number... (7 Replies)
Discussion started by: mojoman
7 Replies
5. Shell Programming and Scripting
Hello guys.
Is there any way I can cut the last field using "cut" ???
(without putting it into a while...)
Thanks.
435 Gavea. (9 Replies)
Discussion started by: 435 Gavea
9 Replies
6. Shell Programming and Scripting
hi all
i am need to cut the name of the file which i am entering in the comand line. say abc.txt is the name of the file i need to cut only the "abc" part. when i try doing this(using cut -f1) i am getting the data that s present inside the file and the file name. pls help.... (3 Replies)
Discussion started by: din_annauniv
3 Replies
7. Shell Programming and Scripting
Hello,
I have got a log file and would need to write a script to cut the every first and second fields of every third line.
Job Name : dummytextd_v1
Status : KILLED
TIMEDOUT 2011-05-01 05:33
Job Name : dummyttx_v1
Status : KILLED
TIMEDOUT 2011-05-03 02:33
Job Name :... (4 Replies)
Discussion started by: Kochappa
4 Replies
8. Shell Programming and Scripting
Thanks a lot for the code and the explanation.
Now my final requirement.
I have uploaded 3 files as attachment. Please open the files in Editplus or any other text editor which keeps the formatting.
GMDCOM.27936.log.txt------I want to pick only Process request from this file.(Please check... (9 Replies)
Discussion started by: ghosh_tanmoy
9 Replies
9. UNIX for Beginners Questions & Answers
I have some data that looks like this:
PXD= ZW< 1,6
QR> QRJ== 1,2(5)
QR> QRJ== 4,1(2)
QR> QRJ== 4,2
QRB= QRB 4,2
QWM QWM 6,2
R<C ZW< 11,2
R<H= R<J= 6,1
R>H XZJ= 1,2(2)
R>H XZJ= 2,6(2)
R>H XZJ= 4,1(2)
R>H XZJ= 6,2
RDP RDP 1,2
What I would like to do is if fields $1 and $2 are... (5 Replies)
Discussion started by: jvoot
5 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I would like to cut the first field and the 2 last fields from the string.Please help.
Here is the example of the string.DL_FUND_FULL_20190605.txt
DL_FUND_HIS_DEL_20190605.txt
DL_FUND_HIS_TMP_DEL20190605.txt
Please noted that
DL_ --> Every files have the prefix like this.... (3 Replies)
Discussion started by: palita2601
3 Replies
LEARN ABOUT PHP
pg_update
PG_UPDATE(3) PG_UPDATE(3)
pg_update - Update table
SYNOPSIS
mixed pg_update (resource $connection, string $table_name, array $data, array $condition, [int $options = PGSQL_DML_EXEC])
DESCRIPTION
pg_update(3) updates records that matches condition with data. If options is specified, pg_convert(3) is applied to data with specified
options.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
o $table_name
- Name of the table into which to update rows.
o $data
- An array whose keys are field names in the table $table_name, and whose values are what matched rows are to be updated to.
o $condition
- 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
updated.
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_update(3) example
<?php
$db = pg_connect('dbname=foo');
$data = array('field1'=>'AA', 'field2'=>'BB');
// This is safe, since $_POST is converted automatically
$res = pg_update($db, 'post_log', $_POST, $data);
if ($res) {
echo "Data is updated: $res
";
} 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_UPDATE(3)