|
01-22-2009, 08:35 AM
|
#1
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Trying to import DRF text chart into Excel
Here is the sample off of DRF's website:
http://www.drf.com/misc/charts/SAR20060727.chart
I copied this and then pasted into a .txt document. I then opened the .txt document in Microsoft Excel in a Comma Delimited format. However, the entire document comes out as one line.
Can anyone who uses these charts and who is familiar with its use in Excel be able to help me???
|
|
|
01-22-2009, 09:15 AM
|
#2
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,889
|
Open Excel, go to Data>Get External Data>Import text file
Follow the prompts.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
01-22-2009, 09:26 AM
|
#3
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Quote:
Originally Posted by Tom
Open Excel, go to Data>Get External Data>Import text file
Follow the prompts.
|
I did. Everything still ends up on one line.
|
|
|
01-22-2009, 11:15 AM
|
#4
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,889
|
I looked at the file - it is spread out over two many lines. The "H" row, I assume is the headers, and each "R" line should be on a single line itself.
Try this - don't paste it, just rename it from XXXXX.chart to XXXX.TXT
This should keep everything line formatted. When you pasted it, I think it got forced into a narrow file format.
I got it to open either using the File Open function from within Excel or from the Import Text File option, but neither one was correct - the data was spread over too many lines.
Don't use "Open with" Excel.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
01-22-2009, 12:05 PM
|
#5
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Quote:
Originally Posted by Tom
I looked at the file - it is spread out over two many lines. The "H" row, I assume is the headers, and each "R" line should be on a single line itself.
Try this - don't paste it, just rename it from XXXXX.chart to XXXX.TXT
This should keep everything line formatted. When you pasted it, I think it got forced into a narrow file format.
I got it to open either using the File Open function from within Excel or from the Import Text File option, but neither one was correct - the data was spread over too many lines.
Don't use "Open with" Excel.
|
That kind of helped, but now the Excel file looks convoluted.
Let me e-mail you the Excel file and the Chart file.
|
|
|
01-22-2009, 12:38 PM
|
#6
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,889
|
Try this file....it should load OK down through R9, then, at the S1, it will not load right.
If that doesn't work, I'll PM you my email addresss.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
01-22-2009, 02:27 PM
|
#7
|
Registered User
Join Date: Dec 2004
Posts: 875
|
That was fine up to where you said it would be.
I have your e-mail address and have already sent you a message.
|
|
|
01-22-2009, 03:05 PM
|
#8
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,889
|
OK,
I'll be home around 6 or so.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|