Extract Folder Name and Date

@KamenRider this sounds like the RegEx tool would be an ideal candidate. The Advanced Certification learning path has a section all about the RegEx tool and would help you figure out the formula to use.

Razb

Hi @KamenRider

@cpet13 is right, the key functionallity for the solution here is regEx.

Attached a sample workflow with the solution as you described.

Let me know if it works for you 🙂

RegEX_Directory.yxmd

OTrieger

There are several ways how to get it done, you can do it with REGEX in formula tool or without REGEX in formula tool, or with REXGEX Parse tool or Text To Columns Parse tool.

OTrieger

While REGEX will work well here I think that there is a better way here to get what you want than with REGEX. With a simple formula tool you need to reverse the text flow, find the first position of the \ then use Left and use the position -1 and then reverse your text and you got the Folder name.

binu_acs

@KamenRider one way of doing this

Regex_12092024.yxmd

KamenRider

Thank @Razb and @binu_acs . I know REGEX is the solution to this case however, I really have a hard time learning from it. Thank you for your solutions.

Kamen

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703