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
 All Forums
 Origin Forum
 Origin Forum
 Importing data into many columns

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
olheiser Posted - 05/04/2004 : 5:56:52 PM
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
1   L A T E S T    R E P L I E S    (Newest First)
Mike Buess Posted - 05/04/2004 : 6:23:02 PM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000