| T O P I C R E V I E W |
| JoseMGuil |
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
|
| 4 L A T E S T R E P L I E S (Newest First) |
| JoseMGuil |
Posted - 10/18/2011 : 2:31:37 PM
Thanks Drbobshepherd. I will try. JoseMGuil |
| Drbobshepherd |
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 |
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 |
| Hideo Fujii |
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
|
