MaximusAurelius 0 Posted January 17, 2016 Report Share Posted January 17, 2016 Having an export issue, after saving a scrape to a table and then saving that table to a csv, when I open the CSV, I have a ton of   and other special characters like Â| in there for things like accented o's or a's, or just in places where there were spaces. When I open the debugger and view the lists in Ubot, there are none of these special characters at all.Any advice for cleaning export files, or better yet ensuring that all exports from Ubot are nice and clean? Quote Link to post Share on other sites
HelloInsomnia 1103 Posted January 17, 2016 Report Share Posted January 17, 2016 When you open up the CSV change the character set to be utf-8 and see if that fixes it. Quote Link to post Share on other sites
MaximusAurelius 0 Posted January 17, 2016 Author Report Share Posted January 17, 2016 Seems to be utf-8 encoding related, however the other issue I'm having is that when I try to switch the encoding to UTF via import data from text in Excel, the address's (which contain a line break and a comma) are getting thrown to new rows). I tried switching the table delimiter to a semicolon, but that still didn't work. Ubot extracted the information perfectly, but going from Ubot to CSV is resulting in some odd row breaks Quote Link to post Share on other sites
HelloInsomnia 1103 Posted January 17, 2016 Report Share Posted January 17, 2016 When you have commas in cells you should surround the cell content with quotations to prevent this. 1 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.