This works to a point...
 
Pattern = "~[^>]*/"
 
And then a /s on the remains, but I wish I could get the ~ and / out so I don't have to do the /s.
 
Anybody?
----- Original Message -----
Sent: Tuesday, June 12, 2001 2:26 PM
Subject: RegEx stripping

I have a thousand rows of data that gets displayed as such;
 
...
<li><a href="http://www.comp.com/~len/">len</a> - Tennis Golf Health and Computer Book Store<br>
<li><a href="http://www.comp.com/~tmaki/">tmaki</a> - Toby Maki/Intermedia<br>
...
 
I need to strip out the data between ~ and / and then CSV the results, doing the CSV part is easy, it's the RegEx I'm stuck with.
 
Something like this... ; SearchPattern = "((\w+)\~([^\s]+\/\w))"
 
No I don't have the RegExp book, and yes I should go buy it...
 
Thanks,
 
Mark

Reply via email to