RE: [Talk] Escape character for quotes

Mon, 10 Jan 2005 14:43:40 -0800

    a = "This is a ""test"""
    If InStr(1, a, Chr(34)) > 0 Then
        MsgBox ("true")
    End If
   
Hope this helps,
Brad

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bates, Bradley M.
Sent: Monday, January 10, 2005 4:34 PM
To: [email protected]
Subject: RE: [Talk] Escape character for quotes

Try
   

If InStr(D("Paragraph"), '"') Then  'single quotes around double quote

or

If InStr(D("Paragraph"), "\"") Then 'Backslash to delimit

or

If InStr(D("Paragraph"), chr(34)) Then 'ascii value of double quote

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Brungardt
Sent: Monday, January 10, 2005 15:25
To: [email protected]
Subject: [Talk] Escape character for quotes

Does anyone know of a way to search for a quotation mark within a string?

I get a compile/syntax error when I try to use the lines listed below.

Thanks!

Paul

 

If InStr(D("Paragraph"), """) Then

Exit Sub

End If

 

 

 

 

Paul Brungardt

Clinical Analyst

HaysMedicalCenter

PH: 785-623-2196

PG: 785-650-5989

 

Reply via email to