Keep everything after the first number in a string

Hello, I am building a workflow that will be able to compare files in two different directories. To ensure that I am comparing the same file from each directory, I want to join on file path. The file paths will be the same after the first number in the string. I would like to keep only the digits after the first number. Below is an example of a file path and what I would like to keep. I have tried regex, but I am afraid that it has not been working out as well as I am not super familiar with regex expressions. I also tried findstring in a formula but it does not work since the numbers will not always be the same. They are essentially a date from when the file was pulled. Thank you in advance for your help.

Example:

Testing_20210730\HP-Testing\resource\Plan Type\Testing\RULES\FTE_BY3.xml

Keep:

20210730\HP-Testing\resource\Plan Type\Testing\Testing\RULES\FTE_BY3.xml

0210730\HP-Testing\resource\Plan Type\Testing\Testing\RULES\FTE_BY3.xml

\HP-Testing\resource\Plan Type\Testing\Testing\RULES\FTE_BY3.xml

Regex

Help

Expression

Accepted answers

atcodedog05

Hi @Link86

Here is how you can do both of them

Workflow:

Hope this helps : )

testing.yxmd

All comments

atcodedog05

Hi @Link86

Here is how you can do both of them

Workflow:

Hope this helps : )

testing.yxmd

Link86

This is perfect thank you. Only one follow up question, what does the $1 actually mean? I tried removing it to see what it did and it just cleared the string all together.

atcodedog05

Hi @Link86

It means content in the first set of round brackets. Its part of parse mode.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

Hope this helps : )

Link86

Awesome, thank you. Also, thank you for the link.

atcodedog05

Happy to help : ) @Link86

Cheers and have a nice day!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335