Jump to content

I thought it was simple, finding quotes


JerrySalem
 Share

This topic is 7290 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all,

as the subject said, I thought it would be simple but...

I have a field that I imported from excel. The values of these are, for some reason in quotes. They need to be removed.

I would like to ultimatly do a find, to get all the records that have a double quote. Then do a replace to remove the double quotes.

First I tried puting just a double quote, then

putting the double quote in double quotes,

then putting the double quote in single quotes,

then putting a single quote in double quotes ( I was getting desperate at this point)

So I must ask the experts!

tia

Jerry

Link to comment
Share on other sites

Do a replace (on a backup!) using the Replace with calculkated result option, where the calculated result would be:

Substitute(textfield, """")

Note the doubled double-quote marks, it's not a typo.

Link to comment
Share on other sites

Woops! shocked.gif" border="0

quote:

Originally posted by Vaughan:

Substitute(textfield, """")

I think you'll need to finish the function:

Substitute(textfield, """","")

Or as an alternative, assuming no other non-indexible characters at the beginning or end of the data in each field:

= LeftWords(textfield, 9999)

Good luck

Link to comment
Share on other sites

Thanks a bunch to all of you. The Substitute command worked fine. I did a replace over the whole dataset. You solved my imediate problem or removing the double quotes.

However just to cover all the bases, we didn't get to the question.

How do I find fields with a double quote in them? That still dosesn't work!

Jerry

Link to comment
Share on other sites

Hi Jerry,

A find on *"""" (shift-8 followed by four double quotes) should find a field with double quotes.

Note however that double quotes are different characters than "smart quotes" (the curly variety of quotes). My recommendation would be to eliminate all smart quotes from your FileMaker diet -- they're basically evil. wink.gif" border="0

First, turn off the smart quotes in your document preferences. Then if you already have them in your field data, use Substitute() to replace them with regular quotes.

Link to comment
Share on other sites

This topic is 7290 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.