eliminate *

[Ron_dK]

I have a field which contains text data. In some of the records, the text starts with *xxx. Other records start with text like xxxx.
I want to delete all the * in those records which start with the *.
How would I do that.

Any help is appreciated.

Thks

 

[wiltshire]

Hi Rak,

You can do this using an update query. Just create an update query based on your table. Choose the field with the text data you want to change.

In the 'update to' row, put: Mid$([Fieldname],2)
In the 'Criteria' field, put: Left$([Fieldname],1)="*"

Where [Fieldname] is the name of the filed holding the data you want to update. Just run this query and it will remove all the "*" as you wanted.

Good luck !

 

[Ron_dK]

Wiltshire,

I have tried so many things and gone to all old threads on this subject , but couldn't get it right.
Your hint worked perfect!
Thanks very dutch.

 

[wiltshire]

My pleasure !!