Regex, alter my one statement to account for 2 scenarios

[wonka1234]

Hi,

I am trying to regex this -

field 1	date
TEST_User_20221031.del	20221031
TEST_User_202210.del	202210

Regex im using on field 1 - 

_(\d+)\.

How can I make it so date is 202210 for both outputs?

[messi007 · Accepted solution]

@wonka1234,

Please see below :

Attached the workflow.

Regards,

[wonka1234]

@messi007 

thanks but what about the +)\.  that you took out? what will happen with that removed?

[binuacs · Accepted solution]

@wonka1234 Another way of doing this