remove apostrophe

[David Devitt]

Hi,

Is there a reason why I can't get a calculation field to remove apostrophes from names to create logins? Substitute seems to remove everything else for me but not apostrophes. Sample included:

Substitute(firstnameimport, "'", "")

I have created nested substitutes to try and remove any extra characters that authentication on various servers may not like.

Thanks

David

[BobWeaver]

It could be that the apostrophe you are trying to remove is actually a single curly quote which is a different character. Depending on what font you are using, they may look identical.

[David Devitt]

Thanks for the fast response. I am now aware that I am unaware of how to insert an apostrophe! However, the single curly quote in the calculation is the same keystroke that is in the field (firstnameimport). I am on a mac (OS X). Eventually, I will import text from an access database, but at the moment I am working with a couple of records, trying to automate some of the import tasks.

David

[David Devitt]

It could be that the apostrophe you are trying to remove is actually a single curly quote which is a different character. Depending on what font you are using, they may look identical.

Sorry for misunderstanding you. It seems smartquotes does need to be turned off.

David

[BobWeaver]

Yes, turn off the smart quote option. Then you may have to use a nested substitute to remove all variations of the apostrophe/quote. The single curly quotes on the Mac keyboard are option-] and option-}. The apostrophe is the key to the left of the return key. A nested substitute that removes all of these is:

Substitute(Substitute(Substitute(TextField,"'",""),"