Using RegEx to split a column at a delimeter

Laf8991

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?

ColemenWilson

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

GrantSmith

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

ColemenWilson

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

GrantSmith

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