| T O P I C R E V I E W |
| originbob |
Posted - 05/05/2014 : 07:54:40 AM
Hello everyone,
the files I have to import into Origin (version 9.1) have a long header which is separated from the useful data by a blank line. Is there any way to tell Origin to simply ignore this header whenever I drag and drop a textfile into Origin? (I know several other ways to get my data into Origin, but a drag and drop solution would be very convinient.)
Cheers,
bob |
| 7 L A T E S T R E P L I E S (Newest First) |
| lkb0221 |
Posted - 06/18/2014 : 10:12:53 AM
Hi,
For those files that the length of header line changes among different files, I'll suggest first import all infos into worksheet and then using script to scan and find the header lines.
But if you don't care the header lines and ok to throw them away, you can just use the "Auto determine header lines" in Import Wizard.
Zheng
OriginLab |
| LC_ |
Posted - 06/18/2014 : 10:01:03 AM
Hi
I have a similar problem. I have some files with variable header lengths, and the last header row is identified by a token (basically a few dashes).
In order to be able to finally import the file with impasc, I need to first be able to identify the row number that contains the token in order to set the header and subheader options from Options.Hdr.
But how can I possibly scan the file before opening them? I could not think of a good workaround so far.
thanks in advance |
| lkb0221 |
Posted - 05/07/2014 : 09:19:10 AM
Hi,
Maybe you can send us (tech@originlab.com) some sample files so we can play with them to see what we can do. Might need a script since the header size is changing...
Zheng
OriginLab |
| originbob |
Posted - 05/06/2014 : 03:16:17 AM
Hi,
unfortunally, the header varies in length, so I cannot use a fixed number of header lines. Also, I do not mind if the column labels cannot be extracted.
Is there a way to have Origin automatically determine the length of the header?
Regards,
bob |
| lkb0221 |
Posted - 05/05/2014 : 1:12:20 PM
Hi,
I mean, in Import Wizard, you can specify the number of header lines and how to extract the column labels. So if all of your data files share the same pattern and can be recognized/handled by this setting, you can save it as an import filter for later use.
Please see the following page for how to use Import Wizard.
http://www.originlab.com/doc/Origin-Help/ImpWiz
Zheng
OriginLab |
| originbob |
Posted - 05/05/2014 : 10:25:00 AM
Hi Zheng,
thank you for your answer. In the dialouge you linked me to, I do not see an option to set a blank line as the dividing element between header and data. I would like to have Origin automatically determine the header (as it may vary in length) and then ignore it.
Maybe I am just missing something obvious here.
Thanks for your help. |
| lkb0221 |
Posted - 05/05/2014 : 10:01:12 AM
Hi,
If all the data files you got have the same name pattern, you can build a import filter to support those particular files.
http://www.originlab.com/doc/Origin-Help/Imp-DragDrop-Basics#Origin_Import_Filters
When drag&drop to import a file, the corresponding filter will be used automatically. You can manage your filters in Tools: Import Filters Manager.
Zheng
OriginLab |
