Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hdiva
Starting Member
10 Posts |
 Posted - 2005-06-27 : 17:37:09
|
| I am working with an editor where documents are created and the documents are stored in a table where the source code is stored in a single field as a string. I need to search through this string and find the document it was created from and all links. This is needed to delete original document and linked documents when the posted document is deleted. I have used InStrRev to search strings but looping through the string to write out all document urls has me confused. Here is an example. In this string there are 3 documents that should be written out. <!DOCTYPE HTML PUBLIC '-//IETF//DTD HTML//EN'><HTML><HEAD><TITLE>Page-1</TITLE><META NAME='GENERATOR' CONTENT='Visio 5.0'></HEAD><BODY BGCOLOR='#ffffff'><CENTER><IMG alt=Page-1 border =0 src='file://O:/Wrkgrp/Halco21/PRef/Manage Product Definition Data.gif' useMap=#visImageMap > </CENTER><P><HR><CENTER></CENTER><BR><CENTER>Page 1 of 1<BR></CENTER><MAP NAME='visImageMap'> <AREA SHAPE='POLY' ALT ='' HREF='Matrix Population of SAP.htm' COORDS='171,543,267,543,267,471,171,471' > <AREA SHAPE='POLY' ALT ='' HREF='Perform Production Release.htm' COORDS='315,435,411,435,411,363,315,363' > <AREA SHAPE='POLY' ALT ='' HREF='Perform Manufacturing Design Review.htm' COORDS='315,291,411,291,411,219,315,219' ></MAP></BODY></HTML> |
|
|
|
|
|
|
|
Searching through a string for documents