Hi,
I want to extract only the email addresses from text string.
this is the text:
"Bob: Bob@abc, Karen: Karen@cde, Sam: Sam@def"
expected output: "Bob@abc,Karen@cde,Sam@def"
"Bob: Bob@abc, Karen: Karen@cde, Sam:Sam@def"
output: "Bob@abc,Karen@cde,Sam@def"
or
"Bob: Bob@abc, Karen: Karen@cde,Sam@def"
output: " Bob@abc,Karen@cde,Sam@def"
"Bob Karen: Karen@cde, Sam: Sam@def"
Output: "Karen@cde,Sam@def"
Thanks,
Discussion posts and replies are publicly visible
Number of ways you could do this. Here is one using the split() function:
a!localVariables( local!text: "name: Bob@abc, name: Karen@cde, name: Sam@def", local!list: split(local!text, ","), a!forEach( local!list, split(fv!item, ": ")[2] ) )
Hi kend0001,
this can be useful,
a!localVariables( local!data: { a!map(name: "Bob@abc"), a!map(name: "Karen@cde"), a!map(name: "Sam@def") }, { a!richTextDisplayField( value: a!forEach( items: local!data, expression: { a!richTextItem( text: fv!item.name ), a!richTextItem( showWhen: not(fv!isLast), text: "," ) } ) ) })
Thanks My data is very inconsistent such as:
"name: Bob@abc, name: Karen@cde, name:Sam@def"
"name: Bob@abc, name: Karen@cde, Sam@def"
"Bob, name: Karen@cde, name:Sam@def"