I'm trying to eliminate the quotes " (double) in a text field by writing a formula that searches for them and does a substitute.

Here's the problem:

Substitute(short_description, "*"*", "")

Obviously that won't work.

Any clues?

TIA!!

-zack

What if you created a global text field an placed a double-quote in it in browse mode. Say it's called gDouble_Quote. Then the substitution would be

Substitute(short_description, gDouble_Quote, "")

Chuck

quote:

---

Originally posted by zackfc:

I'm trying to eliminate the quotes " (double) in a text field by writing a formula that searches for them and does a substitute.

Here's the problem:

Substitute(short_description, "*"*", "")

---

HMM, unless anyone knows how to insert a " into a formula without FMP thinking it is the closing delimiter, I am not sure this can be done.

This is one of those problems like trying to find a way to use reserved words in a programming language.

You could try using a field reference instead. Put the " into a global text field, then structure your substitute with that field.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Hey thanks!

. . . it worked . . . mostly . . .

It removed the first pair of quotes, but if the field contained more than 2, the extras remain:

Example:

8 x 8