I've been tasked with importing table data into a new web application. However, the data is chock full of "bad" characters that are generating tons of errors when I try to import.
There's lots of "Ian\\\\\\\\\\\\\\\\\\\\\\'s home page" and: "That's not the idea; certainly not my idea!" which are wreaking havoc.
There's also instances of double apostrophes and even some HTML thrown in for good measure.
As you can imagine, picking through over 13,000 entries by hand really isn't going to happen. I've written a small PHP script to stripslashes(), but it's not getting rid of all of them, just some.
Does anyone have any tips for cleansing table data?