darkborn
Member
- Joined
- Mar 11, 2009
- Messages
- 455
Probably is easier just to change file extension from .txt to .csv, open it like it is in calc(/excel/similar) and change it with active preview what's going on... "import screen" usually works great.The text file is probably the raw file produced by the survey itself. In order to put that into a Calc spreadsheet you'd need to eliminate the lines with "------" in it, then come up with a separator (I prefer tab or pipe) and import it. Not a whole lot of work if you know what you're doing.
In other words, Craig's file is fine. It's knowing what to do with it that's important.
After that make some data sorting, so that similar data raws come close each other. And THEN swap messed blocks.
Last edited by a moderator: