ORA file exports with formatting issues (Usually the Location field)

Skip to first unread message

Charity Jacobs

Jul 20, 2022, 2:34:52 PM7/20/22
to ORA Google Group

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"
"Vancouver, Canada"



Jonathan Morgan

Jul 21, 2022, 9:20:10 AM7/21/22
to ORA Google Group
Dear Charity,

        I have encountered the same issues. I was working on an e-mail with an example and lines numbers to send to the ORA development team when I saw this e-mail. What I have found works is to export the agent and particularly the tweet node tables as .tsv files. Because Twitter does not permit tabs as part of a character string, they are a safe delimiter. 

                                                                                                                                                                Best Wishes,


Jeff Reminga

Jul 21, 2022, 12:19:27 PM7/21/22
to ORA-goog...@googlegroups.com
Hi Charity,

This has been fixed and will be available in the next release of ORA.


Computational Analysis of Social and Organizational Systems (CASOS)
The Institute for Software Research, Department of Computer Science
Carnegie Mellon University, Pittsburgh, PA, USA
You received this message because you are subscribed to the Google Groups "ORA Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ORA-google-gro...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/cda6e995-d4ab-4b64-bfb2-f4183c8f8655n%40googlegroups.com.
Reply all
Reply to author
0 new messages