Regular Expression / Substring function in Postgresql

Question

I have a list of last names that can have variations like this-->DOE, JR., DO. What I need is a Postgres pattern matching or substring function that will split the DO from the last name and put that a separate column. However, if the pattern is like this DOE, JR. I don't want those split off names suffixes, only professional titles which I need to list like MD, DDS, DMD, or DO. Someone I work with suggested I use something like this -->Substring(last_name, ‘[MD, DDS, DMD, DO,etc.]$’) but that is not working.

select substring('.do' FROM last_name) AS license from table

He might have suggested this (MD|DDS|DMD|DO|etc.)$ . Try it and let me know. — Rahul
– Rahul, Commented May 4, 2017 at 19:01

Leo C · Accepted Answer · 2017-05-04 19:19:40Z

1

Here's one way to get the license (less any trailing whitespace):

select regexp_matches(last_name, '(MD|DDS|DMD|DO|etc)\s*$') AS license from table;

answered May 4, 2017 at 19:19

Leo C

22.5k3 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Regular Expression / Substring function in Postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related