Question : Let’s say I have a text field with this value in Postgres: ‘bar$foo$john$doe$xxx’ I’d like to replace just […]
Tag: replace
Oracle Unknown Character
Question : I have a script, UPPER(REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(TRIM(mbr.mbr_first_name) || ‘ ‘ || TRIM(mbr.mbr_last_name), ‘[-+”=;:,<>?/.~`!@#$%^&*()_-|{}[]]*’,”), CHR(9), ‘ ‘), CHR(10), ‘ ‘), CHR(13), […]
postgresql replace table without losing dependancies
Question : i want to replace an existing table with a new one, without losing foreign keys or inheritance relations. […]
REPLACE(orig,match,replacement) multiple matches in one query
Question : I’m trying to categorize Magic The Gathering cards. Here is a simplified version of what I’m doing/trying. Is […]
Bulk update an address column where the address was duplicated with a delimiter separating the duplicate?
Question : Sorry if my title doesn’t make much sense, I wasn’t sure how to word it though. Basically I […]
performance of Replace vs If exists update else insert vs update if row_count()=0 insert
Question : Structure of my table is: Id int(11) NO PRI auto_increment Mobile varchar(10) NO LoanAmount int(11) NO I want […]
find 16,000 words and replace with ##
Question : I need to do a find a replace but rather than find one word to replace with another […]
Remove text from columns that may or may not be present multiple times
Question : I have the following table in SQL Server 2008. create table OrgUnits ( OrgUnitId int not null constraint […]
Pattern matching and replacement in oracle
Question : So we have a table called TEMPLATES that stores html email templates as plain text (don’t ask, I […]
Cleaning up bad data with REGEXP_REPLACE too aggressive with non latin chars
Question : Trying to use REGEXP_REPLACE to clean up a text field in a table. Here’s my query: select title […]