postgresql extract non alpha numeric

Question

I want to return the non-alpha numeric characters in my character fields in postgresql. Excluding spaces in the result as well. I want to be able to see only all non-alpha numeric characters in my result.

Example:

First Name | Last Name
ABC&DEF    | GHIJ\

Result:

First Name | Last Name
&          | \

How can I do this?

What did you try before you posted this? Where did you get stuck when you tried to solve it yourself, or read other existing answers? — Craig Ringer
– Craig Ringer, Commented Sep 9, 2014 at 8:34

Hasan Ramezani · Accepted Answer · 2014-09-09 20:17:14Z

1

try this:

select regexp_replace(first_name,'[A-Za-z]','','g'), regexp_replace(last_name,'[A-Za-z]','','g') from table_name;

answered Sep 9, 2014 at 20:17

Hasan Ramezani

5,21226 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

postgresql extract non alpha numeric

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