Skip to content

    • Magic ETL

    Magic ETL

    Use Magic ETL to isolate the domain of an email address (company.com).

    Domo Employee
    in Magic ETL

    I am trying to use Magic to isolate the domain of an email address yourname@company.com to just company.com. I am open to any way to do it in Magic. So far the only thing I have found is Regex, but when I put it in, nothing seems to happen. 

    I am using /.+@/

    This seems to work fine in my tests on https://regex101.com/

     

    Thanks!

    Trumpetbob42
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

    Best Answer

    • Domo Employee
      Answer ✓

      You can also use the "Split Columns" tile to accomplish this:

       

      1.png

    Answers

    • Domo Employee
      Answer ✓

      You can also use the "Split Columns" tile to accomplish this:

       

      1.png

    • Domo Employee

      I also found that this would work with the RegEx. As well as the accepted solution. 

      1.  

      Then select replace with empty string in the configuration wheel. 

      Trumpetbob42
      **Say “Thanks” by clicking the “heart” in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories