Offset Data

[ptc-2733614]

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

[ptc-1368288]

"Can't understand data file"
READPRN reads *.txt, but not yours !

jmG

[ptc-1368288]

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

[ptc-2733614]

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

[ptc-1368288]

On 5/22/2009 3:00:42 PM, ScottyC wrote:
>... 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.
>
...
>Thanks,
>Scott
>__________________________

My suggestion was more about creating your own "Data" rather than reading from foreign source. If you are new to Mathcad, it's wise to make things as simple and modular as possible, so you can retrieve yourself in the hay pile.

jmG

[StuartBruff]

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

[ptc-2733614]

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

[StuartBruff]

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