Find and replace within the html of a list

Question

I need to globally update some links in a SP 2010 list using SP Online. The changes require simply changing the domain used in a link from mysite.com to mysite2.com. The field is a rich text field and the html isn't normally exposed so find and replace doesn't work.

So far I've removed disable-output-escaping from the xsl which exposes the html in Sharepoint Designer's design view. But find and replace still does nothing. And though it appears to save okay, the changes aren't reflected in SPO.

Would it be easier to do this with javascript, in the xsl or some other way?

Answer 1

Any chance you can link the list into Access, then run a query to update?  (Or search & replace in datasheet view.)

---

Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of those forum buttons that artificially inflates my narcissitic ego... I mean gives me points.

Answer 2

Thanks for responding. The output in Access or datasheet view isn't formatted as html so find/replace can't update links.

Answer 3

Access formats links like this:

DisplayText#http://www.domain.com

So, you can search for "#http://www.domain", or do a query, you can update it.

---

Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.) Be sure to click one of those forum buttons that artificially inflates my narcissitic ego... I mean gives me points.