Newbies David Devitt Posted April 6, 2003 Newbies Share Posted April 6, 2003 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted April 6, 2003 Share Posted April 6, 2003 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. Link to comment Share on other sites More sharing options...
Newbies David Devitt Posted April 6, 2003 Author Newbies Share Posted April 6, 2003 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 Link to comment Share on other sites More sharing options...
Newbies David Devitt Posted April 6, 2003 Author Newbies Share Posted April 6, 2003 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted April 6, 2003 Share Posted April 6, 2003 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,"'","")," Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7855 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 accountSign in
Already have an account? Sign in here.
Sign In Now