Help finding and databasing similar patterns

[J. Squeed]

I have several HTML files saved in HTML form in a field called
HTMLSTORAGE in a Filemaker database. Each HTML page has several
http:// links in it. I want to be able to extract every link and
store it in a separate database.

How can you do this ?

-Squeed

[J. E. Goodman]

Script I envision something like this.

Count the number of http:// patterncounts in HTMLSTORAGE.
Set a stop loop field to that number
Set a counter field to 1
Loop
SetField CURRENTLINK to middle ( HTMLSTORAGE, starting with [url]http://,[/url]
ending with the next space )
SetFieldLINKSFOUND to LINKSFOUND & ", " & CURRENTLINK
#[Remove the link you've already captured]
SetField HTMLSTORAGE substitute ( HTMLSTORAGE, CURRENTLINK , "")
Exit Loop if COUNTERFIELD > STOPLOOP
End Loop

Contact me directly if you need help.

Jeanne G.
jeanneatdesksideguru.com
[url]www.desksideguru.com[/url]

"J. Squeed" <squeed2000@yahoo.com> wrote in message
news:8e19e59e.0308271815.4502f776@posting.google.c om...

> I have several HTML files saved in HTML form in a field called
> HTMLSTORAGE in a Filemaker database. Each HTML page has several
> http:// links in it. I want to be able to extract every link and
> store it in a separate database.
>
> How can you do this ?
>
> -Squeed