Re: [SQL] regexp_replace behavior

Yes that's exactly what I needed. Thanks a lot. pozdrowienia mk 2012/11/20 Alvaro Herrera > Marcin Krawczyk escribió: > > Hi list, > > > > I'm trying to use regexp_replace to get rid of all occurrences of > > certain sub strings from my string. > > What I'm doing is: > > > > SELECT regexp_repl

Re: [SQL] regexp_replace behavior

Marcin Krawczyk escribió: > Hi list, > > I'm trying to use regexp_replace to get rid of all occurrences of > certain sub strings from my string. > What I'm doing is: > > SELECT regexp_replace('F0301 305-149-101-0 F0302 {x1} 12W47 0635H > {tt}{POL23423423}', E'\{.+\}', '', 'g') > > so get rid of

Re: [SQL] regexp_replace and search/replace values stored in table

-4286-282 yuval_so...@bmc.com -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Leif Biberg Kristensen Sent: Saturday, May 01, 2010 8:29 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] regexp_replace and search/replace values

Re: [SQL] regexp_replace and search/replace values stored in table

Followup II: I've written a blog post on the subject at . regards, -- Leif Biberg Kristensen http://solumslekt.org/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-s

Re: [SQL] regexp_replace and search/replace values stored in table

Followup. Replaced Big Ugly Function with: CREATE OR REPLACE FUNCTION _my_expand(TEXT) RETURNS TEXT AS $$ -- private func, expand various compact links DECLARE str TEXT = $1; links RECORD; BEGIN FOR links IN SELECT short_link, long_link FROM short_links LOOP str := REGEXP_REPL

Re: [SQL] regexp_replace and search/replace values stored in table

On Tuesday 27. April 2010 13.43.48 Leif Biberg Kristensen wrote: > CREATE TABLE short_links ( > link_type CHAR(2) PRIMARY KEY, > short_link TEXT, > long_link TEXT, > description TEXT > ); > > It appears like I have to double the number of backslashes when I enter the > data: > >

Re: [SQL] regexp_replace and search/replace values stored in table

On Tuesday 27. April 2010 15.04.23 Tim Landscheidt wrote: > Leif Biberg Kristensen wrote: > > > [...] > > So far, so good. But when I try to do the actual expansion, I'm stumped. > > > pgslekt=> select regexp_replace((select source_text from sources where > > source_id=23091), (select quote_lite

Re: [SQL] regexp_replace and search/replace values stored in table

Leif Biberg Kristensen wrote: > [...] > So far, so good. But when I try to do the actual expansion, I'm stumped. > pgslekt=> select regexp_replace((select source_text from sources where > source_id=23091), (select quote_literal(short_link) from short_links where > link_type = 'sk'), (select quot

Re: [SQL] regexp_replace and UTF8

On 2009-02-02, Bart Degryse wrote: > > --=__PartF6DE34E1.0__= > Content-Type: text/plain; charset=UTF-8 > Content-Transfer-Encoding: quoted-printable > > Thanks for the ideas! > The function Jasen suggests works partially. > There are also entities like > ‘ > ’ > “ > ” > … these work fine here.

Re: [SQL] regexp_replace and UTF8

Thanks for the ideas! The function Jasen suggests works partially. There are also entities like ‘ ’ “ ” … The output of the htmlent function for these looks like | Was that what you meant with "characters outside of the LATIN-1 space are not handled but apparently this is what you want." ? Because

Re: [SQL] regexp_replace and UTF8

On 2009-01-30, Bart Degryse wrote: > > --=__Part8EA648F8.0__= > Content-Type: text/plain; charset=UTF-8 > Content-Transfer-Encoding: quoted-printable > > Hi, > I have a text field with data like this: 'de patiënt niet' > (without the quotes). > I would like to convert this string to look like this

Re: [SQL] regexp_replace and UTF8

In article <87ljstm4eq@oxford.xeocode.com>, Gregory Stark writes: > "Bart Degryse" writes: >> Hi, >> I have a text field with data like this: 'de patiënt niet' >> Can anyone help me fix this or point me to a better approach. >> By the way, changing the way data is put into the field is >> u

Re: [SQL] regexp_replace and UTF8

"Bart Degryse" writes: > Hi, > I have a text field with data like this: 'de patiënt niet' > Can anyone help me fix this or point me to a better approach. > By the way, changing the way data is put into the field is > unfortunately not an option. > Many thanks in advance. You could use a plperl

Re: [SQL] regexp_replace

thanks / dzieki regards / pozdrowienia mk 2008/8/1 Pawel Socha <[EMAIL PROTECTED]>: > 2008/8/1 Marcin Krawczyk <[EMAIL PROTECTED]> >> >> Hi all. I'd like to know whether it's possible to reverse the >> behaviour of regexp_replace, meaning : >> now if I do >> SELECT regexp_replace ('foobarbaz', 'b

Re: [SQL] regexp_replace

2008/8/1 Marcin Krawczyk <[EMAIL PROTECTED]> > Hi all. I'd like to know whether it's possible to reverse the > behaviour of regexp_replace, meaning : > now if I do > SELECT regexp_replace ('foobarbaz', 'b..', 'X') I get 'fooXbaz' - it > replaces the string that matches given pattern with 'X', how

Re: [SQL] regexp_replace usage

Thanks !Michael Fuhr <[EMAIL PROTECTED]> wrote:Offhand I can't think of a way to do what you want with regexp_replace()but you could use PL/Perl. Something like this should work:CREATE FUNCTION mcfix(text) RETURNS text AS $$ $_[0] =~ s/\bMc([a-z])/Mc\u$1/g; return $_[0];$$ LANGUAGE plperl IMMUTA

Re: [SQL] regexp_replace usage

On Fri, Sep 29, 2006 at 02:31:12PM -0700, chester c young wrote: > column name in table bue has miscapitalized Mc names, eg, 'John Mcneil' > instead of 'John McNeil'. > > (this should be easy but) how do you construct the update query? > > also, regexp_string( 'Mcneil', 'Mc(.*)', initcap('\\1') )