I have an ntext field in a database that contains a page of html. I need to search within the text for every occurrence of a link in the form: “http://127.0.0.1/default.asp?id=1234”
and replace it with “http://127.0.0.1/default.aspx?id=NewID”
i.e. I need to find the occurrence of the url, extract the id, perform a lookup on a table that maps the old ids to the new ones and replace it.
Can anyone give me a pointer as to how to find the url within the text and extract the old id from it?