mosheg
Administrator
mosheg Administrator
Reactions
-
Re: Delete specific word using regexp_replace
SELECT REGEXP_REPLACE('[110 Companies .co]','\.co'); REGEXP_REPLACE ------------------ [110 Companies ] (1 row) And if you want to delete only the last occurrence of '.co' do: SELECT REGEXP_REPLACE('… (View Post)0