Reg Ex difficulty

renee12345

I am attempting to pull out a string using Reg ex.

I want to get the card name, so text after the --- card_name: and between measurable_id.

I am using .*measurable_id) but it is giving me an error message?

Screenshot 2023-01-25 at 9.29.13 AM.png

GrantSmith

Magic ETL formula tile should allow this:

REGEXP_REPLACE(`alert.message`, '^.*card_name: (.*) measurable_id: .*$', '$1')

renee12345

Hi @GrantSmith thanks for the quick response.

It doesn't seem to be working on my end, the result looks the same as the column values :/

renee12345

Does formatting affect regexp_replace?

This is how I'm seeing it exported:

Screenshot 2023-01-25 at 9.53.47 AM.png

GrantSmith

Yes. That would affect the regular expression as there's a newline character prior to your measure_id.

Try this version:

REGEXP_REPLACE(`alert.message`, '^.*card_name: (.*)\nmeasurable_id: .*$', '$1')

renee12345

Unfortunately that version didn't work either :/

Is there another way around using the Replace Text tile?

GrantSmith

Sorry, forgot to have you pass in the 'm' and 'n' flags to the regexp_replace function to tell it to match newline characters with the . reference.

m: Multiple-line mode.

n: The . character matches line terminators.

REGEXP_REPLACE(`text`, '^.*card_name: (.*)\nmeasureable_id:.*', '$1', 'mn')