I've got a database in which URLs are part of the data in some cases, in other cases not, like this:
<a href="http://members.aol.com/instyprnts/">Insty-Prints</a>
<a href="http://www.adpmarshall.com/">ADP Marshall Inc.</a>
University Physicians Inc.
When sorting alphabetically, the results should be:
ADP Marshall Inc.
Insty-prints
University Physicians Inc.
not
Insty-Prints
ADP Marshall Inc.
University Physicians Inc.
If someone could help me with the regular expression to ignore the URL (and where to put it in db.cgi!) I'd be grateful.
Larry
[This message has been edited by Larry Scritchfield (edited March 18, 1999).]
[This message has been edited by Larry Scritchfield (edited March 18, 1999).]
<a href="http://members.aol.com/instyprnts/">Insty-Prints</a>
<a href="http://www.adpmarshall.com/">ADP Marshall Inc.</a>
University Physicians Inc.
When sorting alphabetically, the results should be:
ADP Marshall Inc.
Insty-prints
University Physicians Inc.
not
Insty-Prints
ADP Marshall Inc.
University Physicians Inc.
If someone could help me with the regular expression to ignore the URL (and where to put it in db.cgi!) I'd be grateful.
Larry
[This message has been edited by Larry Scritchfield (edited March 18, 1999).]
[This message has been edited by Larry Scritchfield (edited March 18, 1999).]