If anybody knows a way I could take this data (which is truncated... it's actually thousands and thousands of coordinates) and convert it to a more readable format, that would be great. Point me in the right direction.
There a few things that are going to make Excel choke on that data. One, the data is separated by spaces, not tabs. That makes each line in the file a string that Excel will want to place in a single cell. Two, if the data is straight copy and pasted, excel may choke on the negative values or it may try to truncate the exponential values to its own format.
What I would do is take that text, open it up in an editor that had a find/replace feature that will let you replace with tabs. Replace thos spacers between values with tabs. Then, copy the data, and paste it into Excel using the 'Edit' -> 'Paste Special...' feature, and choose text. Then you should have a nicely pasted rendition of the original data. Once it is in Excel, save as CSV and import into MySQL using phpMyAdmin.
Look at it though... the first row has a 1 in it as the first column... the following lines (until 2) have a space there instead. If I replace all whitespace with just a tab, it will overlook the place where the empty space is supposed to be? Do you follow what I'm saying? I have already tried doing so with a very simple regex.
It appears to be using a "fixed width" formating scheme. Open office can import that without problems. If you want I can have a go at it if you email it to me.
The Ninja Space Goat wrote:Look at it though... the first row has a 1 in it as the first column... the following lines (until 2) have a space there instead. If I replace all whitespace with just a tab, it will overlook the place where the empty space is supposed to be? Do you follow what I'm saying? I have already tried doing so with a very simple regex.
Astions offered to do it for you in OpenOffice. I'll make the same offer in MS Office. Let me know in PM. If you can email it to me (or post the text on the web) I can have a got at it in Excel.
The first record for about 10 of the categories didn't get transferred, other than that it's good to go. The second file is in a different format and will require a different method.
Where can I send the invoice
Last edited by Benjamin on Thu Jul 13, 2006 6:03 pm, edited 1 time in total.