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] ) )
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"