Select word after character

[sinnids99]

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 solution]

I suggest:

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

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

Sample attached

[sinnids99]

Thanks v much, perfect! Is there another solution using RIGHT as well?

[jdunkerley79 · Accepted solution]

Yep.

You could:

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