The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 ASCII Import with filter doesn´t work		  New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

tschunck

Germany
25 Posts
Posted - 01/13/2026 :  09:34:49 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 2025 and Service Release 10.2.0.188
Operating System:win11

Does anyone have experience with the imort wizard concerning search dor a line that seperates header from data.

I do have .tsv- data files with variable header size in which the line ">End of header" seperates header information from rest of file.
Rest of file contains one line with colum names followed by one line with col units. Beginning from next line (3rd under >End of header) data cols with data seperated by tab follows.

The import wizard seems to be prepared for search of a special line as seperator.

Until now in all versions of Origin I never managed to get this feature working.

Do other users experience the same?
Edited by - tschunck on 01/13/2026 09:35:55 AM

snowli

USA
1457 Posts
Posted - 01/13/2026 :  10:02:53 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

The lines at the beginning of data file (above column name and units) are called main headers. The two lines of column name and units are called subheaders, which usually has same separator as data part.

There is an "Auto determine header lines" checkbox in import wizard to detect the main header. Unless there isn't clear-cut different between main and subheaders, it should work.

Could you share an example data file so we could check further?

If you don't want to share the data here, please submit a ticket with data attached
https://www.originlab.com/newticket

Thanks, Snow
Go to Top of Page

tschunck

Germany
25 Posts
Posted - 01/15/2026 :  03:51:09 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
https://my.originlab.com/ftp/forum_and_kbase/Images/Example_tschunck.txt
Go to Top of Page

snowli

USA
1457 Posts
Posted - 01/15/2026 :  11:52:12 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Our CSV connector supports specifying the string to mark the begin of data.

E.g. I can import your data fine by
1. Click the Import Single ASCII toolbar button or Choose Data: Connect from File: TXT/CSV
2. CSV Connector dialog opens to pick the data file.
3. Please make sure "Show Options" checkbox is checked.
4. Expand the Data Block Marker node.
5. In Start field, enter >End of header
6. Check "Data has column name" and "Data has units".
7. Set "Data has comments" to "None"
8. Click OK.

Column A contents are left-aligned which indicates it's not treated as Date/number. I am guessing it's because of "," there. You can
Double click Column A header
Set Format as Date.
Display: Custom Display.
Set the format as yyyy-MM-dd HH:mm:ss,###
Click OK
--> Column A will be date. (right aligned)

Thanks, Snow
Go to Top of Page

tschunck

Germany
25 Posts
Posted - 01/16/2026 :  09:09:05 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you very much. That really works great an helps a lot!
Go to Top of Page
   Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000