Help with a Regex

[kas]

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

[CSmith16]

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

[kas]

@CSmith16 

Data set added.

Thank you,

Kim

[CSmith16 · Accepted solution]

Could be misunderstanding, you mean like this?

Formula that Converts Long Spaces:

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

Formula That Parses Info Out:

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

 

[kas]

@CSmith16 

No, I want to extract the data that is after the 2nd "Scenario:" and stop before the word "Notes:", so the end result in this example would be:

Other.

Thank you,

Kim

[CSmith16]

Yes, check the screenshot the output is in the field named "Test", that is the output I received.

You can edit the formula to replace the current field if you don't need any of the other info, I just wanted to keep that in the answer I gave you to show as a before and after.

[kas]

@CSmith16 

Sorry! I was just looking at it again and had missed the 2nd column after the Test formula - the column was so tiny I missed it at first.

This will work I think...thanks so much!

Kim

[CSmith16]

lol no problem I figured it was just missed is all. Just wanted to make sure that is the output you needed. If this doesn't work, or you need it to be more dynamic I'd be happy to help.