Skip to main content
K
kend0001
August 20, 2021
Question

extract email address from text

  • August 20, 2021
  • 3 replies
  • 0 views

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"

or 

       "Bob Karen: Karen@cde, Sam: Sam@def"

Output: "Karen@cde,Sam@def"

Thanks,

    3 replies

    alex.ladue
    alex.ladue
    August 20, 2021

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

    K
    kend0001Author
    August 20, 2021

    Thanks My data is very inconsistent such as:

    "name: Bob@abc, name: Karen@cde, name:Sam@def"

    output: "Bob@abc,Karen@cde,Sam@def"

    or 

    "name: Bob@abc, name: Karen@cde, Sam@def"

    output: " Bob@abc,Karen@cde,Sam@def"

    or 

    "Bob, name: Karen@cde, name:Sam@def"

    Output: "Karen@cde,Sam@def"

    venkatasaisatyanarayanaraot000
    venkatasaisatyanarayanaraot000
    August 20, 2021

    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: ","
    )
    }
    )
    )
    }
    )

    Terms & ConditionsAccessibility statement