Will this work? UPDATE your_table SET your_column = REPLACE (your_column, 'HVACR1114_LAB_13A.pdf', '&file=HVACR1114_LAB_13A.pdf') WHERE <whatever_expression is needed>;
Your mileage may vary because you have not stated your VERSION of PostgreSQL or your O/S. On Mon, Dec 28, 2015 at 2:10 PM, Christopher Molnar < cmol...@ourworldservices.com> wrote: > Sorry to have to ask the experts here for some regex assistance again. I > am admittadly awful with these and could use some help. > > Have the following string (this is an example) that needs to be changed. > Need to use a search and replace because the links across over 200K records > are similar but not the same. > > '<p>Complete the attached lab and submit via dropbox</p>\r<p><a href=" > https://owncloud.porterchester.edu/HVACR/PCI_GasHeat/GasElectrical/HVACR1114_LAB_13A.pdf"; > title="Lab 13A">Lab 13A<\a>' > > > Need the final string to separate the "LAB_13A.pdf" from the rest of the > URL by inserting a "&file=" in front of it. The final string should look > like: > > > '<p>Complete the attached lab and submit via dropbox</p>\r<p><a href=" > https://owncloud.porterchester.edu/HVACR/PCI_GasHeat/GasElectrical/&file=HVACR1114_LAB_13A.pdf"; > title="Lab 13A">Lab 13A<\a>' > > > 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; > > and the result puts the &file= in the wrong place (at the end of the whole > string). > > > Any suggestions? > > > Thanks! > > -Chris > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
