Extract from file path

[Pmorg73]

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

[WorkingForFood · Accepted solution]

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.

[Pmorg73]

worked a treat thanks