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:
"[email protected];[email protected];[email protected];[email protected];[email protected];[email protected];[email protected];[email protected]" 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:
";[email protected];;;;[email protected];;"
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!