Extract text between two / symbols

Like (0) Share

Report

Posted on 1 Feb 2024 06:09:34 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!

All responses (5)

Answers (3)

ManishSolanki 15,085 Super User 2025 Season 1 on 01 Feb 2024 at 10:17:36

Like (0)

Report

Re: Extract text between two / symbols

Hi @Chriddle

Thanks for sharing. New learning for me 🙂
Verified answer

Chriddle 7,718 Super User 2025 Season 1 on 01 Feb 2024 at 09:22:52

Like (1)

Report
Re: Extract text between two / symbols

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>)
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 01 Feb 2024 at 06:28:35

Like (0)

Report
Re: Extract text between two / symbols

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.
Verified answer

v-jefferni on 01 Feb 2024 at 06:27:14

Like (1)

Report
Re: Extract text between two / symbols

Hi @kajelliott ,

Please try the expression:

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

Best regards,
KE_WSG 2 on 01 Feb 2024 at 06:10:10

Like (0)

Report

Re: Extract text between two / symbols

forgive the spelling - i was in a rush!