Jump to content

Replacing quotation marks


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

Recommended Posts

If a user has a quotation mark (") in a field and I want to remove it, how do I go about doing this?

I tried:

code:


Replace(description,""","")


which would obviously replace any quotations in the field with nothing, but this does not work. An example would be:

Description field:

"This is driving me nuts"

I would want it to be:

This is driving me nuts

Is there any way to do this? Thanks,

Eric

Link to comment
Share on other sites

This should work:

Replace [ description, """", "" ]

I found this in a tech note on FileMaker's web site.

http://tidb.filemaker.com/ti/FMPro?-db=ti.fp5&-lay=list&-sortfield=relevancecalc&-sortorder=descend&-op=eq&product=filemaker%20&-op=eq&article=calculation%20quote&-token.0=filemake r%20calculation%20quote&-token.1=30&-find=&-format=detail.html&-recid=43643

Chuck

Link to comment
Share on other sites

Thanks for the replies. I still can't get it to work after reading the FileMaker tech article.

I created a field called Description.

In the description I have (quotes are part of the field)

"This is just a test."

To test this, I then have a calculation that is "calculate only when needed."

For the calculation I have:

Substitute(description,"""","")

However, it still displays:

"This is just a test."

Any ideas? This is driving me crazy....

Thanks

Link to comment
Share on other sites

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