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
Solved! Go to Solution.
I am curious which solution would be your first choice?