special characters

[CoquinD]

Hi,

this might be easy, but I can't find an answer in the docu:

I'd like to parse a mail in a varchar-field of the postgres database.

Now I got an error because in my String (the mail), there are two "'"s ( the ' )

so the parser thinks that after the ' the input is finished and throws an error.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
|So my question is: How to quote special characters. |
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

And by the way, what other characters should I quote.

&quot;Special&quot; Thx,

CoquinD

 

[Leland123]

Hi CoquinD,

You might try using a back slash in front of the apostrophe like so:

$test=&quot;Peg\'s Antiques&quot;

In the perl programming language using the back slash in front of special characters is called &quot;escaping the character&quot;. Another character in perl that needs to be escaped is the $. For example to print five-hundred and fifty-five dollars in perl without confusing the interpreter that might thing your are refering to a string varabile, I would escape the $ like:

print &quot;\$555.00&quot;;

I know the back slach is needed in front of apostrophes when parsing a string in an insert command to a postgres table, but I'm not sure about the $ sign.
Leland F. Jackson, CPA
Software - Master (TM)

https://www.smvfp.com

Nothing Runs Like the Fox