Need Help with Regex Match Filter on 2 fields

[pvara]

My Sample Data Set as Follows

Invoice Number	Credit Memo Number
340BVIR0000004571	12345
NOMemo	Nomemo
67657676	12346

Regex_Match ([Invoice Number], "^\d\d\d\d.*")

AND

REGEX_Match([Credit Memo Number], "^\d\d\d\d.*")

I would like to see the TRUE to look something like this.

Invoice Number	Credit Memo Number
	12345
67657676	12346

[grossal]

You could do something like this:

This allows you to treat the bad data differently than the good data. Workflow sample attached.

Best

Alex

[pvara]

Hi Alex,

I like your approach however, I was expecting to 2 records for the FALSE for Invoice Number.

Any thoughts?

[grossal]

I think your original Input showed this: 

Therefore I changed the Filter condition from your original AND (that didn't not match your provided data sample) to an OR. If we switch the condition we get two bad and one good:

Updated workflow attached. Is this what you want?

Best

Alex

[pvara]

Hi @AbhilashR 

When reviewing your REGEX_Match Expression

Regex_match([Invoice Number], ".*\d{4,}.*")
AND
REGEX_Match([Credit Memo Number], "[0-9].*")

It did not catch this value for Invoice Number

340BVIR0000004571

If we can catch this value then we will be solid.

Thank you

[pvara]

Hi @grossal 

i believe you attached the incorrect workflow.

[AbhilashR]

Hi @pvara, the output of my workflow matches the original output you were looking to create. What should the output of the workflow be?

[grossal]

I fixed the attachment @pvara. Take another look 😃

[pvara]

Hi @AbhilashR 

What is in the red box should show up in the false in the filter

The non red boxed should be in the true.

[pvara]

Hi @grossal 

can you please reattach the file? 

[grossal · Accepted solution]

Here it is 😃