Extract and assign doc_nmbr using Multi-Row and Regex_Match

[hellyars]

Hi, 

I am having trouble with setting up a multi-row formula with REGEX_Match.

My source data is trapped in a single field.  

Field_1

filename_01-12.pdf

Yada yada yada this is boring

filename_12-92.pdf

Blah Blah Blah is a good song

I want the output to look like this.

DOC_NMBR	Field_1
filename_01-12.pdf	Yada yada yada this is boring
filename_12-92.pdf	Blah Blah Blah is a good song

My Multi-Row tool is set to create a new field called DOC_NMBR.   My Regex Match is set to ^.*?\.pdf.  The expression works correctly by itself using the Regex tool or when testing on Regex_101, but I can't seem to get it to work in this construct.  What am I missing?

IF(Regex_Match([Field_1],"^.*?\.pdf")) THEN [Field_1]
ELSE [Row-1:DOC_NMBR]
ENDIF

Thanks!

[patrick_digan]

@hellyars can you use a contains function instead? contains([Field_1],".pdf"). I would stay away from regex unless necessary. I've attached a quick sample.

EDIT: your formula seems to work on my side, I've updated my workflow.

[MarqueeCrew · Accepted solution]

@hellyars ,

Here's my solution for you... Hopefully you like it.

Cheers,

Mark