Extracting the word to the left after the second "," delimiter.

[DMI10000]

Hi all,
Please I need help with extracting the string to the left after the second ",". See a sample input and output solution below.

INPUT	OUTPUT
17 Randolf Road, FRANKLIN, London 2684	17 Randolf Road, FRANKLIN
10 Music Avenue, MANUREWA, Highbrow 2102	10 Music Avenue, MANUREWA
16 Sheep Road, IBIZZA, Otago 2102	16 Sheep Road, IBIZZA
17 Sea Avenue, FORTWITH, Auckland 2102	17 Sea Avenue, FORTWITH

Thanks

[FinnCharlton · Accepted solution]

Hi @DMI10000 , you can do this with the RegEx tool:

[alexnajm · Accepted solution]

Done!

[binu_acs · Accepted solution]

@DMI10000 Another method

REGEX_Replace([INPUT], '(.*),.*', '$1')

[DMI10000 · Accepted solution]

Thank you all guys. They all worked and I am very grateful!

[alexnajm]

If all helped, can you mark all as a solution? Thank you!