Jump to content

Editing quotation markes " out of text field


sneddens
 Share

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

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?

Link to comment
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

Link to comment
Share on other sites

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