Remove unwanted characters from starting position-CodePudding

Home > Software design > Remove unwanted characters from starting position

Remove unwanted characters from starting position

Time：12-05

Need to remove only characters at the end.

GFG2014JP34343
D2013GH43422
HHH2014JP34343
CC2013GH43422

Output:

2014JP34343
2013GH43422
2014JP34343
2013GH43422

Tried REGEXP with different pattern

CodePudding user response：

We can use a regex replacement here:

SELECT val, REGEXP_REPLACE(val, '^[^[:digit:]] ', '') AS val_out
FROM yourTable;