Love is... A Powerful Text Editor! When you have, as I do, 508 million wonderfully tender pieces of data, the laptop is going to cough and splutter a bit.
After a frustrating 24hrs where I couldn't get the data sorted at all, came salvation.
EditPadPro. This handy gadget was hastily downloaded at Swindon station before the WiFi conked out. It can insert carriage returns wherever you'd like in a long line of data. I wished this to occur every 30,000 characters in order to be re-imported into Excel cells, which have a maximum capacity.
Until I demo'd EditPad I'd not considered that my problem was essentially one of word wrapping. Word wrapping is fiendishly complex, similar to those bucket measuring or optimal grain storage problems from Egypt and Greece. Once you have too much text for a line, we automatically go on to the next line, making decisions about where the words should break. I needed the same approach for my string of values.
The data all lined itself up to be processed like innocent lambs through a sheep wash. It all trotted through and is back sitting pretty in my spreadsheet.
Very hairy moment successfully navigated. Will I finally get the wretched project up and running this weekend? We'll see.
After a frustrating 24hrs where I couldn't get the data sorted at all, came salvation.
EditPadPro. This handy gadget was hastily downloaded at Swindon station before the WiFi conked out. It can insert carriage returns wherever you'd like in a long line of data. I wished this to occur every 30,000 characters in order to be re-imported into Excel cells, which have a maximum capacity.
Until I demo'd EditPad I'd not considered that my problem was essentially one of word wrapping. Word wrapping is fiendishly complex, similar to those bucket measuring or optimal grain storage problems from Egypt and Greece. Once you have too much text for a line, we automatically go on to the next line, making decisions about where the words should break. I needed the same approach for my string of values.
The data all lined itself up to be processed like innocent lambs through a sheep wash. It all trotted through and is back sitting pretty in my spreadsheet.
Very hairy moment successfully navigated. Will I finally get the wretched project up and running this weekend? We'll see.
Posts
No comments:
Post a Comment
Thanks for commenting on my blog! Your comment will be live once moderated. Sorry you have to log in. Not my choice. Tweet if preferred @fh_data_project