I have just imported a few databases into Access and there are extra characters at the end of each phone number like
"7153695054 |1|0| ""(-- ". I want to go thru each record and remove the " |1|0| ""(-- " from each phone number. Does anyone have some suggestions of how to do this besides deleting it record by record. Maybe a short macro or something would do the trick. Any help would be appreciated.. Thanks in advance,
Jeremy
Sincerely,
Jeremy J. Morlock
IT Specialist
PatentWizard, LLC
E-mail: jeremy@PatentWizard.com
Web Site:
"7153695054 |1|0| ""(-- ". I want to go thru each record and remove the " |1|0| ""(-- " from each phone number. Does anyone have some suggestions of how to do this besides deleting it record by record. Maybe a short macro or something would do the trick. Any help would be appreciated.. Thanks in advance,
Jeremy
Sincerely,
Jeremy J. Morlock
IT Specialist
PatentWizard, LLC
E-mail: jeremy@PatentWizard.com
Web Site: