Here is the calc you may want to..
substitute( list( RelatedPortalTO::email ); "¶"; "," )
RelatedPortalTO::email is the field's name on your portal.
I do believe that is exactly what I was looking for. I will give it a try!
Thanks very much!
It worked perfectly the first time. Thanks very much again.
Good to know it.
I have a followup question!
The calculation substitute( list( RelatedPortalTO::email ); "¶"; "," ) works most of the time perfectly.
But for some customer records the result contains a trailing "," character.
I looked at the emails in those cases and don't see anything different in the way they are stored. The emails themselves don't contain "," characters. And there are no extra spaces.
Do you know why sometimes there will be an extra "," at the end?
I don't know what's happening in your case.
But it likely contain extra carriage return in the email field and you cannot *see* it unless you click its field as it's hidden.
If this is the case, this calc will remove the extra one.
substitute( substitute( list( RelatedPortalTO::email) ); "¶¶"; "¶"); "¶"; "," )
It's only happening for a few records. But if I click in the email field it doesn't appear there is a line feed. By that I mean the input cursor is positioned at the end of the email address and it doesn't look like there are extra characters present. Is there a good way to see this "invisible carriage return"?
I'll also test your expression. But the expression you wrote doesn't have balanced parentheses. Is that ok?
I haven't tested it yet.
substitute( substitute( list( RelatedPortalTO::email); "¶¶"; "¶"); "¶"; "," )
This will work..
Is there a good way to see this "invisible carriage return"?
You may find something with this function.
You can also use this expression to avoid nesting multiple substitute functions:
substitute( list( RelatedPortalTO::email); ["¶¶"; "¶" ]; [ "¶"; "," ] )
Well, I feel stupid.
It turns out there was no extra comma after all. The comma-delimited list of email addresses was just a bit too long to fit into the existing text field so it wrapped, breaking at the comma, and I just couldn't see that there was one more address.
In Layout I just stretched the field out a bit and it was fine.
But the functions were definitely educational.