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
 Extracting data based on column values

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
beta3 Posted - 05/05/2015 : 07:08:56 AM
Hello everyone!

I imported data where the first column looks like this:


Index
  0   
  1
  2
 ...
  n
  0
  1
  2
 ...
  m
  0
  1
  2
 ...
  s


Now I would like to extract everything between the first zero and n to one worksheet, everything between the second zero and m to another worksheet and so on. Is there a built-in way to do this?

Any help is much appreciated :)
2   L A T E S T    R E P L I E S    (Newest First)
lkb0221 Posted - 05/05/2015 : 4:25:13 PM
Hi, Beta3

I'm afraid there is no GUI way. Would you mind sending an email to <Tech@OriginLab.com> with your serial number so we can make a simple tool for you?

Zheng
OriginLab
Hideo Fujii Posted - 05/05/2015 : 2:16:17 PM
Hi beta3,

You can try the following method:

1) Highlight all data columns, and copy it (CTRL-C). Open a new worksheet.
2) Start Import Wizard. ("File: Import: Import Wizard")
3) Select "Clipboard" for the Data Source.
4) Set the number of headers/subheaders to 0. Go forward.
5) In the "Data Selection" page, select "Start New Worksheet" for the "Non-numeric data in a numeric field" option. You can press Finish button.

Does it work for your data? As you realize, you could import your original data using the same settings by the Import Wizard so that you could unstack directly at the import time.

Hope this helps.

--Hideo Fujii
OriginLab

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