Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba course - Removing unwanted characters from a text field
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access vba course - Removing unwanted characters from a text field
Resolved · Low Priority · Version Standard
Reply Wed 30 May 2007, 10:18Delegate Richard said...
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
For upcoming training course dates see: Pricing & availability
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
|