Using RegEx to split a column at a delimeter

Laf8991 · 2023-08-18T19:28:33+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

REGEX

Magic ETL

Formulas

Accepted answers

ColemenWilson

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

Screen Shot 2023-08-18 at 1.31.55 PM.png

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

All comments

ColemenWilson

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

GrantSmith

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