agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Rob Sargent <robjsargent@gmail.com>
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Find and replace
Date: Wed, 11 Sep 2019 14:27:48 -0600
Message-ID: <AC2EAA90-71F4-4125-8EEC-2A916B72E48E@gmail.com> (raw)
In-Reply-To: <35490FCC-14AF-4D90-BF6E-A4F00518E41E@illinois.edu>
References: <35490FCC-14AF-4D90-BF6E-A4F00518E41E@illinois.edu>



> On Sep 11, 2019, at 2:24 PM, Campbell, Lance <lance@illinois.edu> wrote:
> 
> 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

Are there curly braces which don’t start/end such strings?  If not it might be easier to just double them up?

view thread (4+ messages)  latest in thread

Message-ID: <AC2EAA90-71F4-4125-8EEC-2A916B72E48E@gmail.com>
Permalink:  ../AC2EAA90-71F4-4125-8EEC-2A916B72E48E@gmail.com/
Also on:    postgresql.org/message-id/AC2EAA90-71F4-4125-8EEC-2A916B72E48E@gmail.com

reply

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: robjsargent@gmail.com, lance@illinois.edu
  Subject: Re: Find and replace
  In-Reply-To: <AC2EAA90-71F4-4125-8EEC-2A916B72E48E@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox