Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Escaping Characters (Double Quotes)


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

Recommended Posts

  • Newbies
Posted

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

Posted

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

Posted

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

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

  • Newbies
Posted

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

This topic is 8811 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
×
×
  • Create New...

Important Information

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