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

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.

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

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

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,"'",""),"