正则表达式抓住最后一场比赛后的所有文字

Question

I am trying to grab the text after the last number in the string and grab the whole string if it doesn't contain numbers.

The best regex I could come up with is:

([^\d\s]*)$

However I found that \s and \d aren't supported in mysql regexp rather [[:space:]] and not sure what \d is equivalent too.

This is what I'm trying to accomplish:

'1/2 Oz' returns 'Oz'
'2 3/4 Oz' returns 'Oz'
'As needed' returns 'As needed'

Answer 1

This is the regex you will need:

/^.*?(\d+(?=\D*$)\s*)/

And just replace matched text with empty string ""

PHP code:

$s = preg_replace('/^.*?(\d+(?=\D*$)\s*)/', '', 'Foo Oz');
//=> Foo Oz

$s = preg_replace('/^.*?(\d+(?=\D*$)\s*)/', '', '1/2 Oz');
//=> Oz

Live Demo: http://ideone.com/u887D7