http://www.perlmonks.org?node_id=554855


in reply to Re: Dirtiest Data
in thread Dirtiest Data

or worse in excel, if they try to sort and don't select all the columns, they mix-n-match data .. e.g. everyone's name or address or something gets jumbled w.r.t their id..


I was given a pile of shi^H^H^Hdata once where the name could be any of the following (sal==Salutation):
First Last Last First Last, First F Last Sal Last Sal First Last Last, Sal Last Sal
We just printed it and had someone visually match up with the ids.