community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Select word after character

Meteoroid

Hi All,

 

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

 

example - abc-de-bravo 1

it should pick out  bravo 1

I suggest:

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

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

 

Sample attached

Meteoroid

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

Yep.

 

You could:

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

 

Labels