The Origin Forum - import of txt file

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

import of txt file

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Fanning

UK
10 Posts

Posted - 07/02/2003 : 10:29:12 AM

Hi,

I have got a txt file, once imported into origin 6.1, it looks like this:
obj.No. Ratio
1 0.85
2 0.866
3 0.771
4 0.867
5 0.927
6 0.868
7 0.89
8 0.885
9 0.903
10 0.851
1 0.852
2 0.869
3 0.778
4 0.865
5 0.931
6 0.868
7 0.891
8 0.895
9 0.9
10 0.85
1 0.852
2 0.871
3 0.78
4 0.864
5 0.934
6 0.868
7 0.89
8 0.904
9 0.897
10 0.848
1 0.839
2 0.861
3 0.778
4 0.85
5 0.922
6 0.856
7 0.877
8 0.899
9 0.877
10 0.831
......

I wonder whether there is an easy way to convert it into a table like this:
obj.No. 1 2 3 4 5 6 7 8 9 10
0.85 0.866 0.771 0.867 0.927 0.868 0.89 0.885 0.903 0.851
0.852 0.869 0.778 0.865 0.931 0.868 0.891 0.895 0.9 0.85
0.852 0.871 0.78 0.864 0.934 0.868 0.89 0.904 0.897 0.848
0.839 0.861 0.778 0.85 0.922 0.856 0.877 0.899 0.877 0.831

......

At moment I am doing it manually in Excel, it is so fustrating. Can anyone help?

Thanks

Fanning

Mike Buess

USA
3037 Posts

Posted - 07/02/2003 : 11:56:10 AM

Hi Fanning,

This is easiest way I can think of...

1. Delete column 1.
2. Edit->Convert to Matrix->Expand Columns (Expansion factor=10).
3. Edit->Convert to Worksheet->Direct.

Easy to try at least.

Mike Buess
Origin WebRing Member

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000