| Author |
 Topic  |
|
|
Dinamik
1 Posts |
 Posted - 09/19/2011 : 4:05:12 PM
|
Origin 7.5 and 8.2, Windows XP
Hello! A have a file of such type: "headers, xy-data, headers, xy-data, headers, xy-data..."
for example:
---
header1-1
header1-2
header1-3
1 5
2 6
3 7
header2-1
header3-2
header3-3
1 5
2 8
3 15
header3-1
header3-2
header3-3
1 10
2 50
3 70
---
If I use Import Wizard and write "3" as a number of headers I get 1 workbook with 2 columns:
---
1|5
2|6
3|7
header2-1|
header3-2|
header3-3|
1|5
2|8
3|15
header3-1
header3-2
header3-3
1|10
2|50
3|70
---
The question is how can I get 3 workbooks with xy-data:
---
1|5
2|6
3|7
---
,
---
1|5
2|8
3|15
---
and
---
1|10
2|50
3|70
I saw, that another user at the same computer did it. There was successful attempt: he only drag'g'droped file and got project with 3 workbooks with data. But after that something changed and we can't get 3 workbooks, we always get 1 workbook.
I suppose, that firstly some import filter was used, but I don't know, what filter. Does someone know, how can I import data in desirable method? |
|
|
greg
USA
1378 Posts |
Posted - 09/26/2011 : 1:31:28 PM
|
Origin considers two types of header:
Header - which is unformatted text
Sub-header - which is text formatted with the same delimiter as data
Origin supports one block of header only. You can have files structured like this:
Header
Sub-header
Data
Sub-header
Data
But your file structure is like this:
Header
Data
Header
Data
If your header lines were sub-headers, then you could you use the
Start new worksheet for Non-Numeric data in a numeric field option in the Import Wizard. As it is, you will have to write your own import code. |
 |
|
| |
Topic |
|
|
|
Import data from xy-file to different workbooks