Re: concat email addresses into a valid string

rmsphoto — Wed, 05 May 2010 19:38:52 GMT

Whew! Took me several minutes to figure out the form... It works perfectly!

Thanks!

Re: concat email addresses into a valid string

Jimmy — Wed, 05 May 2010 18:24:22 GMT

Please see the attached template.

concat email addresses into a valid string

rmsphoto — Wed, 05 May 2010 17:57:20 GMT

I want to combine from one up to about a dozen email addresses from various locations in a form into a properly formatted address string:

"guy1@email.com;guy2@email.com;guy3@email.com;guy4@email.com;guy5@email.com;guy6@email.com;guy7@email.com;guy8@email.com" etc.

but some of the fields can be empty at any time, and I dont want to end up with a string that will fail emailing:

";guy2@email.com;;;;guy6@email.com;;"

I'm thinking concatenate all the email addresses with nothing in between, then use a substring before/substring after with a translate to insert a semicolon after ".com" only when it exists before another letter...?

Note: All the emails will start with a letter, and end with ".com"

I've tried several times, but I am failing, and my brain is melting at the thought of figuring out this logic.

Can someone help? Thanks!

Controls

Re: concat email addresses into a valid string

Re: concat email addresses into a valid string

concat email addresses into a valid string