Jump to content

Calculated replace problem


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

Recommended Posts

  • Newbies

I am trying to replace quotation marks in fields. The "substitute" function does not appear to work with this string:

Substitute(City, """, "")

I want to substitute a single quote mark in the City field with no character. Filemaker keeps telling me that I need an additional quote mark. I think it's reading the text I want to replace (a quote mark) as a quote mark used to surround text.

Any ideas?

Link to comment
Share on other sites

ok, i had this problem once as well.. what i did was this.. i made a global field, and called it quote, then populated that field with a quotation mark ("). then i made my substitute field look like this.

Substitute(City, quote, "")

oh yes, this works best if you turn off smart quotes. (go to document preferences and uncheck "use smart quotes".)

[ March 26, 2001: Message edited by: bman ]

Link to comment
Share on other sites

  • 2 years later...

This topic is 6968 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.