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

All responses (3)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(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.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(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.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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