Remove quoted value in postgresql

Question

I am trying to remove the double-quoted in column values. for that, I am using regex_expression and replace but it doesn't remove the double-quoted can anyone please help me on this

I have value like this

"XYZ.COM "

I need to replace the above as

XYZ.COM

I tried this

regexp_replace(domain), '[^\w]+^.','','g')
replace(domain,'"','')

Note : I don't want to remove the dot from the string

Then show us the complete code you are using because that will definitely work. See here: dbfiddle.uk/… — user330315
– user330315, Commented Apr 22, 2020 at 6:06

Laurenz Albe · Accepted Answer · 2020-04-22 06:30:49Z

1

From the comments I guess that you are not really dealing with regular double quotes but with other characters (the so-called “curly quotes”).

So give the following a try:

replace(domain, E'"\u201C\u201D\u201E', '')

answered Apr 22, 2020 at 6:30

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Comments

Pavel Stehule · Accepted Answer · 2020-04-22 06:15:46Z

0

you can use trim function with extra parameter.

postgres=# select trim(' "' from '"XYZ.COM "');
┌─────────┐
│  btrim  │
╞═════════╡
│ XYZ.COM │
└─────────┘
(1 row)

answered Apr 22, 2020 at 6:15

Pavel Stehule

46.7k6 gold badges103 silver badges102 bronze badges

Collectives™ on Stack Overflow

Remove quoted value in postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related