The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Importing data into many columns
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

olheiser

USA
1 Posts

Posted - 05/04/2004 :  5:56:52 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
I am using Origin 7 and I have data that is in the form:


BEGIN 0
5 -2
4 -1
3 0
2 1
END 0
BEGIN 1
4 -2
2 -1
3 -4
5 -3
END 1
BEGIN 2

and so on. What I want to do is turn these two columns of stacked data sets into a bunch of columns that look like:

5 -2 4 -2
4 -1 2 -1
3 0 3 -4
2 1 5 -3

Thanks in advance,
Tyson

Edited by - olheiser on 05/04/2004 6:31:40 PM

Mike Buess

USA
3037 Posts

Posted - 05/04/2004 :  6:23:02 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
It would help to know your Origin version.

...However, I think you can do it with ASCII Options available in all versions. Start with a blank worksheet and select File->Import->ASCII Options.

File Stucture...
Delimiter: space?
Automatic Determination of column types: check
# lines used for structure testing: 3
When non-numeric is found in numeric fields: Start new Worksheet/Column

File Header...
Skip main header: 0 lines
Auto determine to skip more lines: selected
Max # of line etc.: doesn't matter

# of Columns: Unknown

Import into Worksheet as: New Columns

Other Options... All unchecked.

You'll probably end up with a couple of garbage columns on the right but those settings worked with your data example.


Mike Buess
Origin WebRing Member

Edited by - Mike Buess on 05/04/2004 6:50:58 PM
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000