Parsing path with regex

Question

I have a path C:\1\2\3\4\ but I want to get C:\1\2\3\

Also, how can I get just 2 or 3 alone separately based on pattern.

Again 1, 2, 3 are just examples, want to use a formula tool to get the above. Could someone help me with this? and also explain to me how it works? I would love to understand the logic behind regex_replace.

grazitti_sapna · Accepted Answer

Hi @shravanvijayaprasad  give this a try I hope this will work.

shravanvijayaprasad · Accepted Answer

@grazitti_sapna thank you so much! this did work! I also did it using regex_replace in formula tool, just attaching if anyone wants to use it in the future 🙂