blittle

I think I got the following to work… REGEXP_REPLACE(`Information`, '.?([a-zA-Z0-9.-]+@[a-zA-Z0-9.-]+.[a-zA-Z0-9_-]+).', '$1') It seems to be returning the full email address after an initial test, but I need to open up my filter to look at more rows.

in Isolate email addresses from a column using Magic ETL or BeastMode Comment by blittle March 22

Wow @marcel_luthi, that's definitely closer than I've been! That did semi work. I'm terrible with REGEX, so it's all trial and error for me. It seems to be grabbing the email address, but only returning the last character of the person's name, the @ symbol and domain (example: S@gmail.com). So it appears to be looking at…

in Isolate email addresses from a column using Magic ETL or BeastMode Comment by blittle March 22

Hi Grant, Thank you for the help, I appreciate it! I tried the amended formula you posted, and 'validate formula' seems to like it, but when you run the preview, I am getting a new error. Any thoughts? Thanks again!

in Isolate email addresses from a column using Magic ETL or BeastMode Comment by blittle March 22

For some reason the Formula Tile gives me an Unknown Error Occurred when I try REGEX in the formula bar. That's where I tried it first.

in Isolate email addresses from a column using Magic ETL or BeastMode Comment by blittle March 21

blittle Member

Comments