Help with a Regex

Hello,

I have a scenario I'm not sure how to get the info I need.

In the data set, I'm looking to pull the info after the word Scenario: and stop before the word Notes:

The only problem is the word Scenario shows up twice and I need the 2nd instance. Example below.

Thank you,

Kim

Regex

Preparation

Accepted answers

Could be misunderstanding, you mean like this?

Screenshot 2024-06-05 145923.png

Formula that Converts Long Spaces:

REGEX_Replace([Extended comments],"(\s{2, })","|")

Formula That Parses Info Out:

Replace(REGEX_Replace([Extended comments],"(.*Scenario: )(.*)(Notes:.*)","($2)"),"|","")

You could try parsing it out by doing this below but you should provide this as a data set for me to download.

REGEX_Replace([Column Name],"(Scenario: )(.*)","($2)")

Data set added.

Thank you,

Kim