I've been exporting the Tweet and Agent tables as files from ORA. When I try to import the csv files, I get a lot of formatting issues that I have to clean up manually in an editor before I can work with the data. One big issue I've noticed is the Location field often has crazy formatting specifically with double quotes. This ends up splitting the field into two fields, in which case, some rows will have one more field than it should.
Sed Lex" #Colombia"