Group and Replace is, in my opinion, one of Preps’ most powerful tools. With it you can clean up some very bad data very quickly. I’ve been working with data for almost 20 years, and I’ve never seen anything quite like it in a tool like this.
To start this chapter off, let’s open a new connection to the dirtyData file we worked through in the last chapter. I’ll leave that to you; if you have trouble, you can refer to Chapter 3 for a refresher on connecting to data.