Re: How to Remove <BR> in Fields


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.

On 29 Sep 2005 04:16:59 -0700, "Rolan" <continue@xxxxxxxxxxxxx> wrote:
>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 &nbsp; is not an
>option either. Any assistance will be appreciated. Thanks.


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

.

Relevant Pages

  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... Another bad habit is to store dates as character strings (rely as well ... with the query and modify it to the way I need it and I could not get ... dynamic data back with that said how could I turn this into a dynamic ...
    (comp.databases.oracle.misc)
  • Re: Newbie performance/design question
    ... > character. ... just need to speed up this particular query, ... Pro SQL Server 2000 Database Design - ... > My first thought is to create a new field composed of the above,> concatenated together and separated by perhaps a '|' vertical bar ...
    (microsoft.public.sqlserver.programming)
  • Re: How to trim leading spaces that are not removed by Trim
    ... Just create a new query that is only used to determine the ... imported table and adding a field with the funny character ... as its first character to the field list. ... Then try running the Update query using the value from the ...
    (microsoft.public.access.queries)
  • Re: remove alpha content in text field
    ... >need to check each character. ... >Function ValNumber(strString As String) As Integer ... >Dim intX As Integer ... >You can call it from a query: ...
    (microsoft.public.access.queries)
  • Access 2000 Query using "Between Operator"
    ... I am developing a Query that requires a "Between Operator" ... The problem is associated with the 3 and 4 character ... IF the 3 and 4 character data were excluded ... have tried enclosing the Prompt field with a Val ...
    (microsoft.public.access.queries)