Hi,
I need to extract a folder name after the 5-digit number from a path. There is always a 5-digit number before the path I want to extract. The first part of the path always begins with cnb-fs1\PentaImages-HR-LF\Ready to be Processed\
For example,
I have this path here cnb-fs1\PentaImages-HR-LF\Ready to be Processed\10000\Workers Compensation\10000wc020199.pdf and I need to extract the word "Workers Compensation".
Can I get some help please? I spent half a day looking at this. :(
Thanks!
Faz