Extracting numbers from Folder Path

(0) Share

Report

Posted on by Feisty_Designer

Hello!

I have a folder named

/Shared Documents/Folder/n/

where n is an integer and which i get as an dynamic value FolderPath

How do i extract the n from the name?

I came across Compose > Split suggestion, but i'm a newbie and got lost almost instantly

Thanks!

I have the same question (0)

All responses (3)

Answers (0)

ccc333ab 1,144 on at

Like (0)

Report
Re: Extracting numbers from Folder Path

If the folder path will never change, use the following expression:
last(take(split(variables('FolderPath'),'/'),4))
Just replace "variables('FolderPath')" with your appropriate value.

IF you care to know what this does I've explained below, or you can just cut and paste and go on your merry way!
1. Split will take a string and split it into individual components based on some delimiter, In this case you would use "/" as your delimiter and split will break it into Shared Documents, Folder and 665 (also the before and after blanks).

2. Take will take the x number of values in an array/object, so in this case I am taking the first 4 items of from the split call above (why...the answer is in the next step).

3. And now I can use the LAST function to grab the last item in this split function. Note, the last item from just split is a blank because of the extra / and the end of the folder path.
4. Now you can string all of these expressions together instead of individual steps...but split them to explain this to you. Here it is all in the one expression that I said to use.

And finally the actual run showing the results....

Was this reply helpful? Yes No
Paulie78 8,418 Moderator on at

Like (1)

Report
Re: Extracting numbers from Folder Path

Expression is:

split(outputs('Path'),'/')[3]

Note: This is not extracting a number. It is merely splitting the input string on the "/" character and then taking the 3rd element of that array generated by the split expression. The whole array would look like this:

[ "", "Shared Documents", "Folder", "n", " " ]

The array is numbered from 0, so n is the 3rd element. Make sense?

Was this reply helpful? Yes No
PrasadAthalye on at

Like (1)

Report
Re: Extracting numbers from Folder Path

Try this expression... You can replace path with actual property from SharePoint action...

split('/Shared Documents/Folder/n/', '/')?[3]

Was this reply helpful? Yes No