dbadmin=> SELECT c1, regexp_replace(c1, '\D', '') FROM bunch_of_characters;
c1 | regexp_replace
-----------------+----------------
A1B2C3D4E5 | 12345
ABCDE12345 | 12345
Phone: 555-0100 | 5550100
1!2$3%4^5 | 12345
(4 rows)
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
