我想使用regex\u replace将数字后的数据替换为"".
例如:
input --> output
MA0244891-D --> MA0244891
MA0244891 --> MA0244891
MA0244891D --> MA0244891
0244891D --> 0244891
我try 了以下几种正则表达式替换:
REGEXP_REPLACE(rk.mystring, '[^0-9]+', '')) --> only get numbers
REGEXP_REPLACE(rk.mystring, '[^a-zA-Z0-9]+', '')) ---> get alphanumeric including the last characters
REGEXP_REPLACE(rk.mystring, '[^a-zA-Z][^0-9]+', '')) ---> almost correct but truncate numbers at the back
谢谢你的帮助