Posted: Tue May 10, 2005 5:00 am Post subject: Parsing data
Just downloaded and suitably impressed. One question: Is there a way to parse data in the spreadsheet? I could not see a tool to do that. I get student names in a single column and need to divide them out into separate columns -- what MS calls "text to columns." Thanks to all who have donated their time and energy to produce this amazing product.
Joined: May 25, 2003 Posts: 4752 Location: Santa Barbara, CA
Posted: Tue May 10, 2005 6:55 pm Post subject:
Note: I moved this into the support forum where it'll probably have a better answer.
Worst case scenario, you could always work directly on teh XML with a Perl script or something. The files are just zip archives with a number of XML files. The one you're interested in is named "content.xml".
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum