## Christopher Molnar (cmolnar65@xxxxxxxxx): > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
