Jump to content
Sign in to follow this  
sneddens

Editing quotation markes " out of text field

Recommended Posts

I want to find and replace some double quotation marks in a text field. I can't use the substitute function to get rid of them because it gives an error, it won't find the " character.

Substitute(myfield,""", "")

Is there a way?

Share this post


Link to post
Share on other sites

This is an interesting one! First a definition:

Smart quotes are an option in the Preferences menu for the Document. When using Smart Quotes, FM inserts different characters for the normal quotes, such that the opening and closing quotes are really different characters from each other and from the non-smart quote character. One slants to the right and the other to the left. Non-smart quote marks are straight up and down.

Two cases:

1) If the quotes are not smart quotes, use Substitute(myfield,"""", ""). Note four quote symbols in a row.

2) If the quotes are smart quotes (different open and closed), use two substitute functions and cut and paste to make the inner two quote symbols in the substitute function either the right or left smart quote characters.

-bd

Share this post


Link to post
Share on other sites

Thanks so much. I am in awe of the speed and excellence of your replies.

Soon I hope to be in the position to put my money where my mouth is in gratitude.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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