Origin Ver. and Service Release (Select Help-->About Origin): 8.1 Operating System: Win 8
Hi,
I´m looking for a solution for the following problem. I have lots of laboratory data in lots of .csv. What I need now is i.e. coloumn 7 from row 2789 to row 2987 from each .csv.
I want to use the Import wizard to open let´s say twenty .csv and to get a worksheet with the special columns (+ row to row) next to each other.
You need to use file->import->comma delimited. When you check 'show options dialog' you will be able to choose partial import. You can set it to import specific columns and rows from each file. To have the n-th column from each file in one worksheet you need to choose in the import options-> multi-file (except 1st) import mode->start new columns. Hope this helps. Regards, Gosia
Now there is only one thing missing. The column is always the same in each .csv, but the row isn´t. there is one column which indicates what rows I need.
This testcolumn is full of zeros except in the rows I need. So it would be great, if Origin could check that specific column for "true" to determine which rows to import.
Importing a certain Column or row of ASCII File
Posted - 07/18/2013 : 10:15:03 AM
