OoStatmasteroO
Programmer
Just looking for any tips/tricks you may have for dealing with "messy" data. I am working with some survey data that is pretty messy so I am just interested in how others deal with it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Cleaning
- Thread starter OoStatmasteroO
- Start date
- Status
- Thread starter
- #2
OoStatmasteroO
Programmer
For example, one thing I am trying to do is get rid of any special characters in an ID. I read about the one person using compress or prk, however what if you have an ID with "# 123456" - that would not get rid of the space after the #.
- Status
Similar threads
- Locked
- Question
- Locked
- Question