Last space in string

Like (0) Share

Report

Posted on 25 Feb 2023 12:14:58 by christian12

193

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:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (1)

Pstork1 66,545 Most Valuable Professional on 25 Feb 2023 at 13:35:56

Like (0)

Report

Re: Last space in string

I hadn't noticed that @CNT already answered this.
Pstork1 66,545 Most Valuable Professional on 25 Feb 2023 at 13:34:32

Like (0)

Report
Re: Last space in string

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

CNT 10,919 Super User 2025 Season 1 on 25 Feb 2023 at 12:59:23

Like (2)

Report
Re: Last space in string

@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.