[resolved] Replace comma and the values subsequent with ""

[Anonymous]

I have a column (row1.Fruits_and_Veggies) which has values like

Tomatoes, Potatoes        ---------------------need------------------Tomatoes
Onions, Cabbages          ---------------------need------------------Onions
Oranges, Apples           ---------------------need------------------Oranges

I need to replace the comma and the rest of the string subsequent to the comma with a "" (empty string). How can I accomplish this in tMap.

row1.Fruits_and_Veggies.replace().

[TRF · Accepted solution]

Hi,
Try 

row1.Fruits_and_Veggies.replaceAll(",.*$", "")

Hope this helps.
Regards,
TRF