Data Cleanup

[Sharon]

I import data from many sources and the same type of
information may be formatted differently

For example, contact information is imported from several
sources. The telephone and zip code information may or
may not come with dashes. The names may or may not be
capitalized. Some of the fields have invisible characters
before the name.

I know that there are many individual functions that
perform these tasks. Is there some kind of overall macro
or code that covers the typical scenerios listed above?

 

[Steve Schapel]

Sharon,

Not that I know of. You might want to "roll your own". Possibly the
simplest approach is to set up a series of Update Queries, which you
use macro or code to run sequentially. These would use functions such
as StrConv() to take care of capitalisation requirements, Trim() to
remove leading spaces, and combinations of InStr(), Left(), Mid() to
insert or remove dashes. Good luck!

- Steve Schapel, Microsoft Access MVP