How do i trim out an email address from a field with a string?

How do i trim out an email address from a field with a string?

Example of Field:

Yes, we accept this current pricing and would like to proceed with this order. Thank you, Bob Dole Lab Research Analyst Poss Lab—Dole University [email protected] Thanks


Best Answer

  • GrantSmith
    GrantSmith Indiana 🟤
    Accepted Answer

    Hi @gbennett

    You could utilize a Magic ETL dataflow and a Replace Text tile in combination with a regular expression. It will keep the original value if it doesn't find a valid email address.

    Here's a regular expression which will find an email within a string.

    (\b[A-Z0-9._%+-][email protected][A-Z0-9.-]+\.[A-Z]{2,}\b)

    You can copy and paste the following code into a Magic ETL dataflow which will automatically populate the replace text tile for you:

    {"contentType":"domo/dataflow-actions","data":[{"name":"Replace Text","id":"f04511d9-2fee-4a8b-909f-cf65b6622b8f","type":"ReplaceString","gui":{"x":252,"y":120},"dependsOn":["75646ce3-bee8-4d31-82ca-46451cf82eab"],"removeByDefault":false,"notes":[],"fields":[{"inStreamName":"Column","useRegex":true,"replaceString":"^.*(\\b[A-Z0-9._%+-][email protected][A-Z0-9.-]+\\.[A-Z]{2,}\\b).*$","replaceByString":"$1","wholeWord":false,"caseSensitive":false}]}]}


Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!