Extract text between two / symbols

(0) Share

Report

Posted on by KE_WSG

Hi All,

I am trying to extract text from a certain position in a string.

I need to get any text between the last two / symbols (eg 'extraction)

https://webaddress.com/extracttion/

Can anyone help?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (3)

KE_WSG 2 on at

Like (0)

Report
Copy link

Link copied!

forgive the spelling - i was in a rush!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @kajelliott ,

Please try the expression:

first(reverse(take(split(outputs('Compose'), '/'),sub(length(split(outputs('Compose'), '/')),1))))

Best regards,

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @kajelliott

Pls use the expression to extract the required text:

Below expression needs to bs added in the expression box as highlighted in the above screenshot:

trim(join(take(reverse(split('https://webaddress.com/extracttion/','/')),2),''))

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,667 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Althoughthere is already a good solution provided by @ManishSolanki (and I would go for it), I want to show another easy way:

slice( 'https://webaddress.com/extracttion/', add(nthINdexOf('https://webaddress.com/extracttion/', '/', -2), 1), nthINdexOf('https://webaddress.com/extracttion/', '/', -1) )

You can find the last positions in a string by using negative numbers as occurrence in nthIndexOf().

nthIndexOf('<text>', '<searchText>', <occurrence>)

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Chriddle

Thanks for sharing. New learning for me 🙂

Was this reply helpful? Yes No