Filter out all URL's?

[Eric]

I have the following situation: A have a column Varchar(ntext) that contains
(most of the time) url's. I would like to be able to filter out all the url's
and move them to a different column. Is there a simple and easy way to
accomplish this? Thanks.

 

[Daniel Pineault]

It is hard to help without some more details, but if your urls start with
http:// or www. then you could create a query to update your url to your
secondary column using a criteria which use the left() function to only
affect those with the urls.

left([FieldNameWithURLs],3) = "www"
left([FieldNameWithURLs],4) = "http"
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.