[thelist] regexp in MSSQL?

Joel Canfield joel at spinhead.com
Thu Dec 5 01:05:00 CST 2002


--
[ Picked text/plain from multipart/alternative ]
> For now, you could simply patch the problem by telling your
> server side script to do the regex work, while you are
> fetching the data. Make it look for the CDNow links and
> replace it with whatever you need in your parse/get routine
> for the DB.

Excellent idea

> This regex will work:
> <a.*CDNOW.*</a>

Only if there's just one link; if there are two, regexps are greedy; it'll
replace everything from the <a of the first link to the </a> of the last
link. But it's the right place to start.

> and a helpful link: http://www.evolt.org/article/rating/20/22700/

Oh look; a note about greediness and a solution.

Thanks for the excellent pointers, aleem.

joel



More information about the thelist mailing list