Richard has attended:
Access Advanced course
Removing unwanted characters from a text field
I have been provided a text file that I have imported into Access 2003. The file contains over 190,000 records.
One of the fields is a contact ID, an example of a contact ID is as follows:
{0000001F-0000-0000-0000-000000000000}
I want to remove the { } from every contact ID
I have been playing around with the Left and Right commands but cannot get it to work.
When the first { is removed I do not want it replaced with a space, but instead the entire contact id is to move one space to the left.
The right } just needs to be removed.
Can you please advise me on the best way of achieving this?
Thank you
Richard
RE: Removing unwanted characters from a text field
You can use Find and Replace to do this.
-Open the table
-Open Find and Replace (Ctrl+H)
-enter { in the find box
-leave the replace box empty
-under LOOK IN select the field you want to look in
-under MATCH choose Any part of field
Let me know if that works
Regards
Richard
