Using RegEx to split a column at a delimeter

I currently am working with a column that is delimited using underscores. I was able to write the following RegEx in a builder which was able to do what I needed: ^(?:[^_]+)

What is the best way to implement this RegEx to return the part of the string that this captures?

Best Answers

  • ColemenWilson
    edited August 18 Answer ✓

    Have you looked at the Split Column tile in Magic ETL?

    If I solved your problem, please "accept" my answer as the solution

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can use a formula tile and the REGEXP_REPLACE function to get just the value of your match. There isn't a regex substring function so you essentially have to match the entire string and then replace it with your value:

    REGEXP_REPLACE(`field`, '^(?:[^_]+).*$', '$1')
    

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

Answers

  • ColemenWilson
    edited August 18 Answer ✓

    Have you looked at the Split Column tile in Magic ETL?

    If I solved your problem, please "accept" my answer as the solution

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can use a formula tile and the REGEXP_REPLACE function to get just the value of your match. There isn't a regex substring function so you essentially have to match the entire string and then replace it with your value:

    REGEXP_REPLACE(`field`, '^(?:[^_]+).*$', '$1')
    

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