Skip to content

    • Magic ETL

    Magic ETL

    REGEX Extracting Names

    Member
    in Magic ETL

    Hello, Regex question here..

    I am attempting to extract names from a string similiar to this but haven't had any luck:

    Submitter:

    ["Joe Smith ","Jill Smith"]

    I would like to retain the commas between names so that I can split these values to different columns afterwards, like this:

    Desired Result:

    Joe Smith, Jill Smith

    Any suggestions on a regular expression that will perform this in ETL would be much appreciated.

    Thanks,

    Mycah

    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

    Best Answer

    • Coach
      edited March 2023 Answer ✓

      I would use the formula tile and use the replace function multiple times to remove those characters.

      Something like this:

      REPLACE(REPLACE(REPLACE(fieldname,'[',''),']',''),'"','')

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Answers

    • Coach

      Are you simply looking to just remove the open and close brackets and the double quotes?

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Hi @GrantSmith. I am looking to remove the open and close brackets, double quotes, and return the result into a new column. Preserving the comma so that I can split the names into multiple columns later.

      I was attempting to complete this with the Replace Text tile in ETL. But had no luck.

    • Coach
      edited March 2023 Answer ✓

      I would use the formula tile and use the replace function multiple times to remove those characters.

      Something like this:

      REPLACE(REPLACE(REPLACE(fieldname,'[',''),']',''),'"','')

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Member

      Thank you @MarkSnodgrass , worked like a charm!

    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