Ghoast 0 Posted May 21, 2012 Report Share Posted May 21, 2012 I have a bot which takes data from a .csv file and inputs it into different websites in html format.. It's just a simple blog posting bot however any text that it uses from the .csv file has a problem: it takes all the apostrophes: ' and replaces them with � when it's input into html.. Everything looks fine in the csv - for example this sentence: Please don't believe everything you see on the internet Would change into: Please don�t believe everything you see on the internet once it's been put into the html editor on a site.. I've tried everything - I've used different csv editors - I've changed the apostrophes to different types using find and replace. There are different types of apostrophes and I've used them all - ’ 'I've also made sure that my csv editor is using ISO-8859-1 character set - the same one used on most browsers.. but still NOTHING works.. How can I fix this?! Quote Link to post Share on other sites
Legend 181 Posted May 21, 2012 Report Share Posted May 21, 2012 It sounds like an encoding issue... you might try a simple replace to replace all the �'s with genuine apostrophes... Quote Link to post Share on other sites
Ghoast 0 Posted May 21, 2012 Author Report Share Posted May 21, 2012 It's a character set issue - needed to make sure right character set is being used when csv saves - OpenOffice doesn't give the option 100% of the time.. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.