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.
reverse(
take(
reverse(
split(
'This is the users FirstName LastName.',
' '
)
),
2
)
)