this seems to work but it changes other characters it isn't meant to change.
basically,
i want to replace "/[#|^ with exactly "^\[\#\|
It is all about what gets escaped and what doesn't.
(") doesn't get escaped
(/) it does get escaped (\/)
([) it does get escaped (\[)
(#) doesn't get escaped
(|) doesn't get escaped
(^) it does get escaped (\^)
(\) it does get escaped (\\)
I bet you can conjure a proper syntax that will match what you want.
i have a text file which domains something like this
123213213213/32434342
324324324/12312321321
12321321,435435435
12321312 / 12313213 / 12435435345
4353213 , 123213213213
21321321312-12334324
234324324 - 235645645645
456456456 - 45456456456 - 45645645654243
how can i replace '/' and... (4 Replies)
Hi, I have a script for replacing bad characters in filenames
for f in *; do mv $f `echo $f | tr '+' '_'`
done;
this replaces + for _
But I need to replace all bad characters ? / % + to _
Pls how can i do this in one script ? (3 Replies)
hi all
I have a file that has sone spaces in start then / at last. i want to get rid of this. how to do?
eg.
11414/
49878/
27627/
I WANT THE FILE AS
11414
49878
27627
PLEASE HELP (3 Replies)
Hi All,
I have a file which is delimeted with the character '. i need to replace this character with the same character and also a new line.
Can anyone please help me with the tr command for this.
Many thanks
Karan (11 Replies)
Hi All,
example data.log
526569346 66815531961 09
526569346 66815531961 09
526569346 66815531961 09
526569346 66815531961 09
526569346 66815531961 09
I want like this to
526569346|66815531961|09
526569346|66815531961|09... (4 Replies)
Hi fellow experts,
I have a question for you. Data looks like:
00877,05/13/2010,PBO,P,0000708331,518
00877,05/13/2010,PBO,P,0000708331,519
...
...
00877,05/13/2010,PBO,P,0000708331,2103
00877,05/13/2010,PBO,P,0000708331,2104,etc,etc
Basically I have to replace 518,519,2103,2104,... (4 Replies)
The Problem
I have n files all named "conf.cfg", each of which contain a line that reads: "MyVar=XXX", where XXX can be any value.
I have a second file called report.xml, that might read:
<Reports>
<Report>Report1</Report>
<Report>Report2</Report>
<Report>Report3</Report>
</Reports>
I... (1 Reply)
sed -e "s// /g" old.txt > new.txt
While I do know some control characters need to be escaped, can normal characters also be escaped and still work the same way? Basically I do not know all control characters that have a special meaning, for example, ?, ., % have a meaning and have to be escaped... (11 Replies)
Suppose I have a file which has 1000 columns (5 SHOWN FOR EXAMPLE)
two alphabets are separated by a space and then tab
A A"\t"C C"\t"G G"\t"0 0"\t"T T
A G"\t"C C"\t"G G"\t"A T"\t"0 0
G A"\t"0 0"\t"G C"\t"A A"\t"T C
whenever there is a 0 0 in any column, the output should be printed as
A... (12 Replies)
Discussion started by: rossi
12 Replies
LEARN ABOUT PHP
pg_escape_string
PG_ESCAPE_STRING(3)PG_ESCAPE_STRING(3)pg_escape_string - Escape a string for querySYNOPSIS
string pg_escape_string ([resource $connection], string $data)
DESCRIPTION pg_escape_string(3) escapes a string for querying the database. It returns an escaped string in the PostgreSQL format without quotes.
pg_escape_literal(3) is more preferred way to escape SQL parameters for PostgreSQL. addslashes(3) must not be used with PostgreSQL. If the
type of the column is bytea, pg_escape_bytea(3) must be used instead. pg_escape_identifier(3) must be used to escape identifiers (e.g. ta-
ble names, field names)
Note
This function requires PostgreSQL 7.2 or later.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $data
- A string containing text to be escaped.
RETURN VALUES
A string containing the escaped data.
CHANGELOG
+--------+-------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-------------------+
| 5.2.0 | |
| | |
| | $connection added |
| | |
+--------+-------------------+
EXAMPLES
Example #1
pg_escape_string(3) example
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Read in a text file (containing apostrophes and backslashes)
$data = file_get_contents('letter.txt');
// Escape the text data
$escaped = pg_escape_string($data);
// Insert it into the database
pg_query("INSERT INTO correspondence (name, data) VALUES ('My letter', '{$escaped}')");
?>
SEE ALSO pg_escape_bytea(3).
PHP Documentation Group PG_ESCAPE_STRING(3)