| Author |
 Topic  |
|
|
JoseMGuil
Spain
11 Posts |
 Posted - 10/14/2011 : 09:40:52 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 7.5 SR6
Operating System: XP Pro
My data.DAT (ASCII) file has the structure:
short-name; .... (n columns)
long-name; ....
Datum; ....
Datum; ....
.........
How can I import all the data in such a way that "short-name"s become column names and "long-name"s become column labels; if possible, by appropiate "ASCII import options" only and without using programming facilities. So far, I have been able to get "short-name"s as column names but column labels became a two lines text with the "short-name"s and "long-name"s in them.
Thanks
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 10/17/2011 : 10:26:26 AM
|
Hi JoseMGuil,
I think you are confused something about the feature differences between versions of Origin. Origin 7.5 doesn't have the worksheet structure of the long name/short name etc. as it was introduced in Origin 8.0. So, you have nothing to do for the long names, and only what you can do is to put them in the column labels.
--Hideo Fujii
OriginLab
|
 |
|
|
JoseMGuil
Spain
11 Posts |
Posted - 10/17/2011 : 11:19:28 AM
|
quote:
Originally posted by Hideo Fujii
Hi JoseMGuil,
I think you are confused something about the feature differences between versions of Origin. Origin 7.5 doesn't have the worksheet structure of the long name/short name etc. as it was introduced in Origin 8.0. So, you have nothing to do for the long names, and only what you can do is to put them in the column labels.
--Hideo Fujii
OriginLab
Hi Hideo Fujii,
Thanks for your reply.
My aim was: 1) content - short - of first line of columns be read as column name. 2) Content of second - long - of second line of columns be read as column label. In fact, the situation is not bad now: first line is read as column name, and first + second lines are read as column label; so one can manually erase first line from the column label, and that is. I tried to avoid that manual operation so my question.
JoseMGuil |
|
|
|
Drbobshepherd
USA
Posts |
Posted - 10/18/2011 : 1:07:58 PM
|
| In the "Import Wizard-Header Lines" window, set "Column label lines: from 2 to 2", then save this import filter. Next time you import one of your .DAT files, use this filter instead of the default one. It should only read the data from line 2 into your column labels. |
|
|
|
JoseMGuil
Spain
11 Posts |
Posted - 10/18/2011 : 2:31:37 PM
|
| Thanks Drbobshepherd. I will try. JoseMGuil |
|
|
| |
Topic |
|
DAT file headers and column name and label