Skip to main content
P
ptc-27336141-Visitor
1-Visitor
May 22, 2009
Question

Offset Data

  • May 22, 2009
  • 2 replies
  • 2236 views
I am trying to import some data from a .txt file for some analysis. For some reason the data is offset in the .txt format and affects the import. See the attached .txt file as well as the .xmcd. (Names, values and length of file are changed)

So the values for the last column, N, is on the next line. So I was wondering what the best way to approach this, so I can still have the values of N, but delete every other row in the table so that the other columns are correct.

Thanks,
Scott

2 replies

S
StuartBruff23-Emerald V
23-Emerald V
May 22, 2009
On 5/22/2009 1:04:20 PM, ScottyC wrote:
== I am trying to import some data from a .txt file for some analysis. For some reason the data is offset in the .txt format and affects the import. See the attached .txt file as well as the .xmcd. (Names, values and length of file are changed)
== So the values for the last column, N, is on the next line. So I was wondering what the best way to approach this, so I can still have the values of N, but delete every other row in the table so that the other columns are correct.

Cat skinning exercise.

Top of the head ...

Stuart
P
ptc-27336141-VisitorAuthor
1-Visitor
May 22, 2009
On 5/22/2009 3:21:50 PM, stuartafbruff wrote:

>
>Cat skinning exercise.
>
>Top of the head ...
>
>Stuart


Works perfect!!
Thanks alot for the help!

Thanks,
Scott
S
StuartBruff23-Emerald V
23-Emerald V
May 22, 2009
On 5/22/2009 3:54:17 PM, ScottyC wrote:
On 5/22/2009 3:21:50 PM, stuartafbruff wrote:
>>Cat skinning exercise.
Works perfect!!
Thanks alot for the help!

No worries.

Much shorter, but equivalent version, at bottom of attached.

Stuart
P
ptc-13682881-Visitor
1-Visitor
May 22, 2009
"Can't understand data file"
READPRN reads *.txt, but not yours !

jmG
P
ptc-13682881-Visitor
1-Visitor
May 22, 2009
On 5/22/2009 1:43:39 PM, jmG wrote:
>"Can't understand data file"
>READPRN reads *.txt, but not
>yours !
>
>jmG
_____________________________

Put your data in a Mathcad input table,
for a stand alone work sheet and keep
collabs machine clean from foreign files.

jmG
P
ptc-27336141-VisitorAuthor
1-Visitor
May 22, 2009
Sorry, I am new to posting here and did not know the exact procedure. I was able to input my data into a table using
READFILE("file","delimited"). This still had the last data value N offset to below the timestamp.

I will wait to upload a .xmcd file because I am not sure what you mean a stand alone worksheet, do you want just the table in it?

Thanks,
Scott

Terms & ConditionsCookie settingsAccessibility statement