Blacksabbath
New Member
A file like this: \[code\]fieldname_A: eggsfieldname_B: bacon ~EOR....~EOR~fieldname_A: eggsfieldname_C: spamfieldname_Z: baked beans~EOR~\[/code\]in total, 40 different field names, about 10,000 records (EOR is End Of Record) with a variable set of fields in them. Most field content is short, some is very long (over 1000 characters). I'm looking for a nice, clean, pythonic way to transform this to CSV, or rather, to a Google spreadsheet. (The data needs to be checked and corrected. Several people will do this. A google doc is the only fast way I know for them to work on the same data without causing version conflicts or syncing problems.)Dictwriter seems like a cumbersome way, because many records (ie rows in a the spreadsheet) have fields in them that are empty. The form of the input file is more XML-ish, so I'm thinking to transform it to XML, import that into Excel, and then upload it as Google spreadsheet. Any ideas?