Thank you both. Problem solved - worked perfectly. On Wed, Dec 9, 2015 at 5:41 PM, Jerry Sievers <gsiever...@comcast.net> wrote:
> Christopher Molnar <cmol...@ourworldservices.com> writes: > > > Hello, > > > > I am running into a problem and need some pointers on regexp_replace - I > can't seem to find an answer in any of the online resources. > > > > I have a string (like 40,000 with different length and number of > components) of them in a field named "externalurl". I need to replace the > final "/" of the string with > > "&file=" while preserving the filename and extension following the "/". > > > > The closest I can get is: > > > > regexp_replace('http://test.com/test/testfile.php','/[^/]*$','&file=') > > > > however this looses the file name and returns: > > > > http://test.com/test&file= > > > > What I am looking for is: > > > > http://test.com/test&file=testfile.php > > > > as a result. > > > > Would anyone here point me in the right direction? > > > > select regexp_replace('http://foo/wow/blah/zzz.php', '/([^/]*)$', > '&file=\1'); > regexp_replace > ---------------------------------- > http://foo/wow/blah&file=zzz.php > (1 row) > > > > > > Thanks! > > -Chris > > > > -- > Jerry Sievers > Postgres DBA/Development Consulting > e: postgres.consult...@comcast.net > p: 312.241.7800 >