RE: [Talk] Escape character for quotes

[Paul Brungardt]

Thank you to all who responded!  I took me awhile to get a chance to try your suggestions.   I found that this line of code answered my question: If InStr(D("Paragraph"), chr(34)) Then 'ascii value of double quote   But….. that my problem was still not solved!  I found out that what looked like a quote in a Word document was unrecognized by BW.  Using a hex editor, I found out that the character I wanted to block was really 148.  So I used that instead of the 34.  Also, for those of you who are interested, I believe my unrecognized character is a “smart quote” from MS Word.   Thanks Again! Paul     Paul Brungardt Clinical Analyst HaysMedicalCenter PH: 785-623-2196 PG: 785-650-5989 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rich McNeil Sent: Tuesday, January 11, 2005 7:27 AM To: Talk@BOSTONWORKSTATION.COM Subject: RE: [Talk] Escape character for quotes   The proper syntax uses four double quotes for InStr’s second parameter:   If InStr(D("Paragraph"), “”””) Then       Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Brungardt Sent: Monday, January 10, 2005 5:25 PM To: Talk@BOSTONWORKSTATION.COM 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