PostgreSQL regexp_replace() to remove Brackets(Example)

Question

I have addresses like this

420 CONSUMER SQUARE (PET SMART PARKING LOT)

in a column and I want to remove the brackets and the word in that and the result should look like

420 CONSUMER SQUARE

How can I do this in PostgreSQL?

Vaishali Shinde · Accepted Answer · 2016-11-09 12:33:36Z

13

Please try this

SELECT regexp_replace('420 CONSUMER SQUARE (PET SMART PARKING LOT)', '$.*$', '');

answered Nov 9, 2016 at 12:33

Vaishali Shinde

5524 silver badges12 bronze badges

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

Comments

pumbo · Accepted Answer · 2016-03-14 11:58:53Z

2

You need to use regexp_replace function

SELECT regexp_replace('420 CONSUMER SQUARE (PET SMART PARKING LOT)', '^(.*)\\(.*?\\)', '\\1')
-- or
SELECT regexp_replace('420 CONSUMER SQUARE (PET SMART PARKING LOT)', '\\(.*?\\)$', '')

Both examples will return 420 CONSUMER SQUARE

edited Mar 14, 2016 at 11:58

answered Mar 14, 2016 at 11:52

pumbo

3,9162 gold badges29 silver badges29 bronze badges

5 Comments

Deepan Kaviarasu Over a year ago

I have lots of this in a column with different address name so where can i put the column name in this ??

pumbo Over a year ago

@DeepanKaviarasu SELECT regexp_replace(address_column_name, '\$.*?\$$', '')

Deepan Kaviarasu Over a year ago

"SELECT ColumnName, (regexp_replace(ColumnName, '$.*?$$', '')) from TableName " will this work ??

Deepan Kaviarasu Over a year ago

10 NO WHITE HORSE PK (PARKING, New Jersey - What should I do if column has single open bracket like this example ??

pumbo Over a year ago

@Vaishali I tested it on the exactly same version (9.3.5). What does it show when you run the query above?

Collectives™ on Stack Overflow

PostgreSQL regexp_replace() to remove Brackets(Example)

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related