Re: Simple Regex question, hoping for direct answer (no Socratic approach necessary)

["Albe Laurenz" <all@xxxxxxxxxxxxxxxxx>]

Postgres User wrote:
> I'm new to Regex in Postgres.  Can someone give me a quick pointer on
> how I'd SELECT the substring between   '<name>'    and  '</name>'  in
> a field?
> 
> Sample field data:
> address city here <name>Rogers, Jim</name> zip code place
> 
> and I'd like the SELECT to return only:
> Rogers, Jim

SELECT regexp_replace(
          'Sing along with <name>Rogers, Jim</name>',
          '.*<name>(.*?)</name>.*',
          E'\\1');

 regexp_replace 
----------------
 Rogers, Jim
(1 row)

Yours,
Laurenz Albe

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly