Select word after character

Question

Hi All,

I need to pick the rightmost words after the character "-"

example - abc-de-bravo 1

it should pick out  bravo 1

jdunkerley79 · Accepted Answer

I suggest:

REGEX_Replace([Field1], "^.*-", "")

This will replace everything up to the last - with an empty string.

Sample attached

jdunkerley79 · Accepted Answer

Yep.

You could:

RIGHT([Field1], FindString(ReverseString([Field1]),"-"))