Regex Match and trim if a record ends with certain numbers

[D_Y]

Hi 

I have a list of records that look like this:

Alpha

2 Bravo

18 Charlie 34

Delta12

1 Echo1

Foxtrot8

I am trying to use the Regex_Match function to identify records where the last OR second character is a 1. In this case, Delta12 and 1 Echo1.

Afterwards, I need to remove any character including and after that 1, i.e. return Delta and 1 Echo. 

How would I build this out?

Thanks in advance! 

[dYoast · Accepted solution]

Try this.

First RegEx:

Formula is:  .*1{1,}\d?

Second RegEx:

Formula is:  (.*)1{1,}\d?

End Result:

[D_Y]

Thank you!