Remove HTML Code by Query from a Field in Microsoft Access
Posted on 2007-12-06
i manage monthly uploads to a number of different shopping channels. google base is one of these channels. the data that i have comes preformatted by my client. for google base, the feed can be in text delimited format. i manage this data in microsoft access 2003. recently, my feeds are being disapproved because they have changed their requirements. a required field is a description of the product but cannot be the same as the product title. the description field that i have in the preformatted file from my client includes HTML code, with many different tags. i need to remove all these tags before upload. obviously each tag begins with "<" and ends with ">", but there are many variations within the tag.
my question is, how do i write this query (queries)? query (queries) would be run monthly, as the client sends me a new database for upload every month.
i greatly appreciate your expertise and look forward to your helpful resolution.
the database holds >20,000 records.