Extract the last symbols from a string

[Rurikovich]

Hi all,

Recently I worked with Alteryx and the following question appeared:

How to extract the last symbols after the combination of “,” (coma and space)?

For instance, I have such rows:

1234 Metal, Wood, Containers, units
435792 Red bricks, t
38 Fresh Juice, aka Maracana, l

And I want to get the following column;

units
t
l

As you may have noticed, there are several combinations of “, “ in a string. However, their number may vary from 1 (the exact one before the units) to 4-5. So just splitting the text to columns using ", " does not help to create a column with a necesary data.
Could you please advise me, how it can be done?

Thanks

[papalow]

@jdunkerley79 

I am curious which solution would be your first choice?

[jdunkerley79]

Regex replace - but then I love Regular Expressions (my team hates me for them). 

I expect performance of reverse find might be faster but generally wouldn’t be stressing over that level of optimisation and if I was would want to implement a true FindLast implementation. 

James