Last space in string

(0) Share

Report

Posted on by christian12

204

Hi Guys,

Trying to figure out how to get the last space within a string and then extract all characters after the last space.

This is a dynamic string and not in all instances will the string have a space. I only need to extract all characters after the last space if there is a space.

Any help is greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@christian12

This will return a Blank as there are no spaces,

With({myString:"Apples,Oranges,Bananas"}, If(IsMatch(myString, Space, Contains), Last(TrimEnds(Split(myString, " "))).Result, Blank()) )

This will return 🍌🍌🍌

With({myString:"Apples,Oranges, Bananas"}, If(IsMatch(myString, Space, Contains), Last(TrimEnds(Split(myString, " "))).Result, Blank()) )

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Pstork1 69,024 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I think the easiest way to do what you are asking is to use a combination of Split and Last functions.

Last(Split(<<string to extract from>>,' '))

Split will split the string into an array based on the spaces in the string. Then Last will give you whatever follows the last space.

Was this reply helpful? Yes No
Pstork1 69,024 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I hadn't noticed that @CNT already answered this.

Was this reply helpful? Yes No