take data from the last - symbol

Question

I want to take date from the last '-' which could be any but I always have to pick the last

NameAsh Ketchum - US10100Jhon-King - US10302Big -Dog - KL0920King - Pin - UIO10203Bruce Wayne - UK10920

Output:

NameValueAsh Ketchum - US10100Ash KetchumJhon-King - US10302Jhon-KingBig -Dog - KL0920Big -DogKing - Pin - UIO10203King - PinBruce Wayne - UK10920Bruce Wayne

Amit_G_Limbasia · Answer

Dear @Sshasnk

You can use the function called reverser string then use get right then reverse again as you just want to extract left part you can use this also.

Workflow attached. Thanks

Solution 5555.yxmd

Wesley Mendonca · Answer

Hi Sshasnk,

You can use  Regex Tool to solve your problem.

I attached a model to use in this case that you inserted as example.

exemplo_regex.yxmd

DataNath · Answer

Hey @Sshasnk, if you place a RegEx tool on your canvas and set the Output Method to 'Parse', the following expression will work:

(.*)-

If the hyphen always comes after a space, use the following so you don't need to then trim/clean up the parsed field afterwards:

(.*)\s-

Hope this helps!

Extract up to last hyphen.yxmd