Pulling quotes

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

2 questions. I have a bunch of text in a field that is enclosed in quotes. I
got rid of the quote mark at the beginning by searching-and-replacing " at
the start of field.

How can I get rid of the quote mark at the end? First, how can I pull the
records that have it with a query? I mean, how do you put the quote mark
into the expression?

I tried ["] and ' " ' but they didn't work.

And 2nd, what expression can I use to remove the mark from the end of the
text, which are all different lengths?

Thanks, Jill~
 
Use The Find/Replace (the binoculars) to find and replace them. Select the
field, then choose Any Part of the Field, and let her rip.
 
2 questions. I have a bunch of text in a field that is enclosed in quotes. I
got rid of the quote mark at the beginning by searching-and-replacing " at
the start of field.

How can I get rid of the quote mark at the end? First, how can I pull the
records that have it with a query? I mean, how do you put the quote mark
into the expression?

I tried ["] and ' " ' but they didn't work.

And 2nd, what expression can I use to remove the mark from the end of the
text, which are all different lengths?

Thanks, Jill~
Click to expand...

Couple of ways. To find records containing a " character (anywhere in the
field) use a criterion of either

LIKE '*"*'

or

LIKE "*""*"

To remove all doublequote characters in a field (permanently and
irrevokably!!!) you can run an Update query updating the field to

Replace([fieldname], """", "")

That's four doublequotes and then two doublequotes; to include a doublequote
character in a string delimited by doublequotes use a double doublequote
(how's that for doubletalk!!)
 
Back
Top