Required help in Trimming the last word

Question

HI,

I have an input like this

A, HEKOBO SOMTRI-SOMTRI
ALJKJERO, NAMI TA ZZZ-ONP32

and I need output like this
A, HEKOBO
ALJKJERO, NAMI TA

basically I want to remove the bold letter mentioned in the input, which is nothing but the word after the last space in the input.

thanks in advance

afv2688 · Accepted Answer

Hello @cghat,

Try using this:

(.*\,.*)\s(.*)

What it does is just taking the last word after the last space and takes it off

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

RolandSchubert · Accepted Answer

Hi @cghat ,

an option would be to find the first ' ' beginning at the end and cut the characters left to this space. Attached a sample. Hope this is helpful.

Best,

Roland