Jump to content
Sign in to follow this  
dulux

Joining Strings

Recommended Posts

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.

Share this post


Link to post
Share on other sites

Create a new calculation field, "EmailAddress" = field1 & field2.

If you want to include spaces, then,

= field1 & " " & field2

Share this post


Link to post
Share on other sites

Cracking! Thanks for your time and help there. Feeling a little silly here but hey, that's learning. :

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    twelvetens 
×

Important Information

By using this site, you agree to our Terms of Use.