## Christopher Molnar (cmolna...@gmail.com): > I have tried something like: > > update pcilms_assign set intro=regexp_replace(intro, '/([^/]*)\" title=$', > '&files=\1') where intro like '%https://owncloud.porterchester.edu%' and > course=18 and id=55413;
http://blog.codinghorror.com/parsing-html-the-cthulhu-way/ But you were close: regexp_replace(intro, '/([^/]*)" title=', '/&file=\1" title=') looks like it's doing the right thing on your example. Regards, Christoph -- Spare Space -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
