How to Remove <BR> in Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rolan - 29 Sep 2005 12:16 GMT

I need to be able to remove <BR>'s that are placed in null fields
(Access 97) for blank records when doing html imports. Of course,
Access does not recognize the html tags and are invisible. Aside from
pressing the delete key twice in each null field to remove the <BR>'s,
I have found no other effective way of deleting them. The real data is
too randomized to run a delete query against. Using   is not an
option either. Any assistance will be appreciated. Thanks.

Reply to this Message

Chuck Grimsby - 29 Sep 2005 22:39 GMT

I'm not really too sure what you are asking for here....

Personally however, I can't say as I've ever had a case where I
couldn't run a query to update a field to remove a specific character
or set of characters.

The Replace function wasn't available until Access 2000, but it's not
all that hard to build your own for Access 97, or use one of the many
solutions that have been posted here in the past.

Before you have fixed your data though, you _will_ want to come up
with a solution to make sure they don't go back in. In many cases,
you will want to implement that solution seconds after you fix your
data.

Without knowing how you are getting the data into your database
however, I can't really offer a solution. If your data is getting
there via ASP or .Net or something like that, you'll want to ask the
people in a newsgroup devoted to that for a viable solution.

>I need to be able to remove <BR>'s that are placed in null fields
>(Access 97) for blank records when doing html imports. Of course,
[quoted text clipped - 3 lines]
>too randomized to run a delete query against. Using   is not an
>option either. Any assistance will be appreciated. Thanks.

Signature

Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

Reply to this Message