Delete * from my data

[Gekko . via AccessMonster.com]

I have data like this in my table:

*NE7353
* NE7928
**SNE800877
*HW30146**

I want a query that removes the * from the data.

Thanks

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=6444d13cb3ad4d3caf056404546616e9
*****************************************

 

[Allen Browne]

Use an Update query.

1. Create a query into this table.

2. Change it to an Update query: Update on Query menu.
Access adds an Update row to the grid.

3. Assuming the field is named "MyField", type this into the Update row
under this field:
Replace([MyField], "*", "")

4. Run the query.

Access 2000 may have problems using Replace() in a query. If you are using
this version and run into trouble, see:
http://support.microsoft.com/?id=225956

Your 2nd example would end up with a leading space. If you wish to remove
that also, use Trim().

You may be able to make the update run faster by using criteria of:
Like "*[*]*"

 

[Michel Walsh]

Hi,


With Access 2002 or later:

- make a backup (copy the dot-mdb file)
- run the query:

UPDATE tableName SET fieldName =REPLACE( fieldName, "*", "" )


the last, third, argument of REPLACE is two double-quote, nothing in between
them. Replace tableName and fieldName as appropriate, for your case.


Hoping it may help
Vanderghast, Access MVP