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?

 

[Media Lint]

No, create any necessary update queries and fire them off
after importing the data. I see this every day.

For example:
UPDATE Monster SET Monster.ReqNumber = Val(Left
(Monster.Jobrefcode,7))
WHERE (((Monster.Jobrefcode) Like "[2-8]??????_*"));