Last space in string

(0) Share

Report

Posted on by christian12

178

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 64,741 on at

Like (0)

Report

Re: Last space in string

I hadn't noticed that @CNT already answered this.
Pstork1 64,741 on at

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 on at

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.