Parsing Double Quotes

P

Public Served

I need to parse double quotes out of a text field, naturally leaving
the rest of the field's content intact.

Is there a way to accomplish this through a query?
 
A

Allen Browne

You can use the Replace() function to replace the double quotes with
nothing/something else
Replace("My ""dog"" has flees.", """", "'")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing double quotes from field names 0
Password protect new workbooks from template 0
Parse Suffix from Last Name Field 4
Word hangs on inserting punctuation mark and deleting another 1
Parsing Full Name and Title/degree 7
PARSE DATE FIELD 5
Append Crosstab Query to Existing Table 0
Parsing out Initial and period Only 1

Top