From: Campbell, Lance <lance@illinois.edu>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Find and replace
Date: Wed, 11 Sep 2019 20:24:07 +0000
Message-ID: <35490FCC-14AF-4D90-BF6E-A4F00518E41E@illinois.edu> (raw)
PostgreSQL 10.x
I don’t know the best way to do this. I need to do a find and replace in text fields. The value I need to find and replace may occur more than once in each field per record.
The value I am trying to match on:
Starts with a single { .
Ends with a single } .
In between these brackets can be the characters 0-9, a-z, A-Z, hyphens and underscores. But no spaces. These characters could be in any order.
The replacement value on a match is the same as what was found except for double {{ at the beginning and double }} at the end. Same values between the brackets as what was matched on.
Example:
{ab_1D3-4} becomes {{ab_1D3-4}}
Thanks for helping me with this.
Lance Campbell
University of Illinois
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lance@illinois.edu
Subject: Re: Find and replace
In-Reply-To: <35490FCC-14AF-4D90-BF6E-A4F00518E41E@illinois.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox