take data from the last - symbol

[Sshasnk]

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

Name

Ash Ketchum - US10100

Jhon-King - US10302

Big -Dog - KL0920

King - Pin - UIO10203

Bruce Wayne - UK10920

Output:

Name	Value
Ash Ketchum - US10100	Ash Ketchum
Jhon-King - US10302	Jhon-King
Big -Dog - KL0920	Big -Dog
King - Pin - UIO10203	King - Pin
Bruce Wayne - UK10920	Bruce Wayne

[DataNath]

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!

[Wesley Mendonca]

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.

[Amit_G_Limbasia]

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