S
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?
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?