dulux Posted January 28, 2009 Share Posted January 28, 2009 Hi all, Still pretty new and need a little help. I would like to take 2 strings from different fields and join them together in another field to create what amounts to an email address. I have done this in other apps but cannot locate the calculation method in FM9. I am sure there is an easy way to do this as the scripting engine seems powerful, but it is not apparent to me at the moment. Thanks in advance for your advice and support. Link to comment Share on other sites More sharing options...
bcooney Posted January 28, 2009 Share Posted January 28, 2009 Create a new calculation field, "EmailAddress" = field1 & field2. If you want to include spaces, then, = field1 & " " & field2 Link to comment Share on other sites More sharing options...
dulux Posted January 29, 2009 Author Share Posted January 29, 2009 Cracking! Thanks for your time and help there. Feeling a little silly here but hey, that's learning. : Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5538 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