text data manipulation
Posted on 2009-05-14
I recently received a screenscrape of a website. The references to images in content was scrambled. Fortunately there is a pattern to the scramble so I believe an Update statement or query can remedy the situation. I would appreciate to be provided with the statement and/or string manipulation code to get this done.
Here is the broken pattern: <IMG SRC="filename.pdf? images kb site>
Here is what it needs to be: <IMG SRC="/kb/images/filename.pdf">
We have removed the "site" folder in our new system.