View Single Post
  #3 (permalink)  
Old 10-05-2007, 03:10 PM
alfcen's Avatar
alfcen alfcen is offline
Basic4ppc Veteran
 
Join Date: Apr 2007
Location: Okinawa, Ryukyu
Posts: 424
Awards Showcase
Beta Tester 
Total Awards: 1
Default

Hello Put,

Hard to say without seeing the data and without knowing what you wish to match, however, you could save the table as XML and use the RegEx.dll to match a criteria, such as:

Code:
Match1.New1
Regex1.New2("<longitude\b[^>]*>(.*?)</longitude>", true, false)
Match1.Value = Regex1.Match(m)
longitude=StrReplace(Match1.String,"<longitude>","")
longitude=StrReplace(longitude,"</longitude>","")
This example will pick a longitude embraced in the XML <longitude> </longitude> tags or whatever the tag names is in the XML file.

I have only little experience with the RegEx.dll, but it seems to be very fast. Please have a look at Help for the RegEx.dll.

Cheers
Robert
Reply With Quote