18

I have column with text where I need to change characters! For example

  • �ay----> need to be Day
  • �rag---->need to be Drag

So I need to replace � with character D. I try next but I get error:invalid regular expression: quantifier operand invalid

update  tableT pp set descript=(select regexp_replace(descript,'�', 'D') 
FROM 
  tableT kk where pp.id=kk.id) ;
user238271
  • 643
  • 3
  • 11
  • 27

2 Answers2

21
update tableT pp
set descript = (select replace(descript, '�', 'D') from tableT where id = pp.id)

Why don't use replace?

President Camacho
  • 1,860
  • 6
  • 27
  • 44
14

It's just a plain UPDATE:

update  tableT set descript= regexp_replace(descript,'�', 'D')

add where descript like '%�%' to minimize transaction.

Or, as President Camacho says, why not use replace instead of regexp_replace?

jarlh
  • 42,561
  • 8
  • 45
  • 63