Split and extract words from a sentence

(0) Share

Report

Posted on by Saideep

Hi,

I have a text sentence called: This is the users FirstName LastName. Now I want extract the Last two words from the sentence and store them in variables, say varFirstName and varLastName. The sentence would keep changing but for any input text/sentence, I want to get the last two words and store them as separate variables. Using Last(Split()) function as power fx in automate, I was able to get the Last word, but where I am struck is at, to get the last before word.

Please could anyone help me on this?

Thanks.

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Chriddle 8,416 Super User 2025 Season 2 on at

Like (0)

Report
Re: Split and extract words from a sentence

reverse( take( reverse( split( 'This is the users FirstName LastName.', ' ' ) ), 2 ) )

Was this reply helpful? Yes No