How to plot a text file having a large block of delimited numbers?

[macilrae]

I am trying to import space-delimited numbers from a .TXT file and then plot the result in Excel.

I have a text file which consists of a sequence of 10,000 three-digit numbers 000 - 999, delimited by a space. The sequence must be read from left to right.

Here is a snippet, the data is put in an SD card by a tiny electrocardiograph machine I've made:

136 136 136 136 136 136 137 137 138 138 139 139 139 140 140 141 142 142 141 141 141 141 140 139 137 137 136 136 135 136 136 136 136 136 135 135 136 136 155 175 195 197 179 156 140 135 134 134 134 135 135 135 135 135 134 135 136 136 136 136 136 136 136 137 137 137 138 138 139 139 139 139 140 141 142 143 144 144 145 146 147 148 150 151 152 153 154 154 154 154 154 154 154 152 151 149 147 145 144 142 141 139 138 137 137 136 135 135 136 136 136 136 136 136 136 137 137 137 136 137 137 137 137 137 137 137 137 137 137 137 137 137 136 136 136 137 137 136 136 136 135 136 135 135 135 136 135 136 136 136 136 136 136 136 136 135 135 136 136 137 137 137 137 136 137 136 137 138 137 137 136 136 136 137 138 138 139 138 138 138 139 140 140 141 141 141 141 141 142 142 142 141 140 138 137 137 136 137 136 136 136 135 136 136 136 136 136 136 136 135 138 146 161 183 198 188 167 147 135 134 133 134 134 135 134 133 134 134 134 135 134 135 135 135 136 136 136 137 137 137 137 138 138 140 141 141 142 144 144 145 147 148 148 149 150 151 152 153 154 153 153 152 152 151 151 149 147 145 143 142 140 138 138 137 137 135 135 135 135 135 135 134 135 135 136 136 136 136 136 136 136 137 136 136 136 136 136 136 136 136 135 136 136 136 136 135 135 135 136 135 136 136 136 136 135 135 136 136 136 136 136 136 136 136 136 136 137 136 136 136 136 137 137 137 137 137 137 137 136 136 137 137

Ideally I'd like to import all of these data as one very long column, 10,000 cells tall, and then I know how to plot that.

I can import line by line from notepad by doing cut and paste but it is impossibly tedious.

I'd be grateful for your help.

[Portuga]

Would upgrade to at least excel 2007 or make this particular task in a PC with 2007 be an option?
2007 has over 16.000 columns.

If you copy + paste from the txt file, you would get the 10.000 in order, in a single row.
Then its a simple matter of copy+paste special: transpose that row,

[FDibbins]

Hi and welcome to the forum

Your profile says 2003, is that correct?

I presume this will not be a once-off task? Is there any way to import the data in a different format?

[macilrae]

Portuga - I am using Excel 2002 and so I get overspill when I import the text; I had not realized that >2007 had so many columns. I wish I had it now. Thanks for the reply.

FDibbins - Thank you for your welcome. This is Excel 2002 and I am therefore limited to 256 columns for import.

You mentioned another format, what would you suggest? I could format the text file to have a row delimiter using a different character, would that help? I do ultimately contemplate huge files (too big for Excel) but I want to use Excel to get my bearings as I refine my hardware/software.
Regards
Mac

[FDibbins]

Any change you could upload a sample file here for us to play with?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[macilrae]

FDibbins - thanks for taking the time - I have attached the file.
Regards
Mac

[AndyLitch]

This seems to work ok... Give it a try

Please Login or Register  to view this content.

[macilrae]

SOLVED!

AndyLitch - That is just plain lovely! Thank you so much for your trouble; could not have asked for more.

Regards
Mac