G
Guest
What is the best approach to clean out data from various
sources (excel, linked tables, other databases) when
importing? Cleaning out data is not a one time occurance
but it is a daily requirment in my role as a report
specialist.
For Exp:
- Zip Code fields may be imported without dashs
- Data from some systems may include invisible lead
characters
- Percentages are imported in various formats
- Character case may be in all lower and I would like to
see them as "John Smith"
Should I use macros? VB? Find and Replace?
sources (excel, linked tables, other databases) when
importing? Cleaning out data is not a one time occurance
but it is a daily requirment in my role as a report
specialist.
For Exp:
- Zip Code fields may be imported without dashs
- Data from some systems may include invisible lead
characters
- Percentages are imported in various formats
- Character case may be in all lower and I would like to
see them as "John Smith"
Should I use macros? VB? Find and Replace?