Remove the "*" from a table

  • Thread starter Thread starter PJFry
  • Start date Start date
P

PJFry

I am working with a database where the user has inserted the "*" character in
some of the names. As a result it is creating havoc with some queries. Is
there a way to isolate and remove that character?

Thanks!
PJ
 
Got it done using the old Gates trifecta.

I queries all the wildcards out using Like "*[*]*"
Copied that into Word and did a find and replace on the *
Copied that table into Excel
Imported the worksheet into accesss and ran an update query.

Take that Gates!

PJ
 
I don't know if you are using VBA in any way, but finding a
character in a string and removing it is easy using the InStr( )
function along with the Left( ) and Right() functions. These
VBA functions could enable you to run a subroutine that could
find and remove every instance of the character "*" in a field of
a table.

Roger


I am working with a database where the user has inserted the "*"
character in
some of the names. As a result it is creating havoc with some
queries. Is
there a way to isolate and remove that character?

Thanks!
PJ
 
Sure was a lot of work. An update query that would update using a
calculated value would have done it in one pass:

Replace([FieldName],"*","")

PJFry said:
Got it done using the old Gates trifecta.

I queries all the wildcards out using Like "*[*]*"
Copied that into Word and did a find and replace on the *
Copied that table into Excel
Imported the worksheet into accesss and ran an update query.

Take that Gates!

PJ


PJFry said:
I am working with a database where the user has inserted the "*"
character in
some of the names. As a result it is creating havoc with some queries.
Is
there a way to isolate and remove that character?

Thanks!
PJ
 
Back
Top