Substituting the ' punctuation

[michele]

To export my data to the web I need to substitute: ' with '

example: I'm Michele, becomes I'm Michele.

Apparently filemaker doesn't understand my calculation:

Substitute(detail_user, "'", "'")

Because nothing changes. How can I make this calculation work? The version I'm working with is FM5.0.

Thank you for reading and eventually answering my question.

[Lee Smith]

Hi Michele,

Your calculation Substitute(detail_user, "'","'") works for me. Do you have Smart Quotes on? If so, turn it off in the Document Preferences.

HTH

Lee

[michele]

Really weird, I've turned them off and still the calculation doesn't work.

Hmm..

Nono, my mistake, just had to refresh. Great. Thanks for the answer.