cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pmorg73
Helper II
Helper II

Extract from file path

Hi everyone

 

I have googled this and find answer for original flows byt not the newer PAD.

 

I have a flow running that captures the folder path 

 

such as this:

 

Z:\3.0 Project Files\2020 Projects\2011-3167 - 4 Platinum Ridge, Peninsula Bay, Wanaka\C - Construction Monitoring\Construction Notes

 

I would like to split this and extract the 8 digit job reference number. The red letters above.

 

i could not see an easy way to split the out put by deliminator in PAD.

 

any suggestions or reading material for this?

 

Phil

1 ACCEPTED SOLUTION

Accepted Solutions
WorkingForFood
Advocate IV
Advocate IV

There is a Split Text action where you can use a custom delimiter. Then you could use the Get Subtext action to trim the results to the 8 digit job reference number.

View solution in original post

2 REPLIES 2
WorkingForFood
Advocate IV
Advocate IV

There is a Split Text action where you can use a custom delimiter. Then you could use the Get Subtext action to trim the results to the 8 digit job reference number.

worked a treat thanks

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (3,782)