Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Remove unwanted characters from starting position

Need to remove only characters at the end.

GFG2014JP34343
D2013GH43422
HHH2014JP34343
CC2013GH43422

Output:

2014JP34343
2013GH43422
2014JP34343
2013GH43422

Tried REGEXP with different pattern

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

We can use a regex replacement here:

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

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading