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
 All Forums
 Origin Forum
 Origin Forum
 Problems Importing Files: Origin insists on CR on header line (or screws up impo-

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
a_user Posted - 08/19/1998 : 5:07:00 PM
Since I started using Origin a few days ago, I have been bedevilled by problems
importing data from ASCII text files into Origin. Even when, with the help of
scott of Microcal tech support (who was very helpful), I ended up disabling the
so-called "intelligent" format deduction, specifying the format explicitly and
completely by hand :-(.

These problems have included:

a) Origin telling me that a perfectly legitimate file was not legal ASCII

b) Origin deleting the first one or two characters of the first field of the
first data row of a file (the second line, after the headers).

BUG FOUND: although Origin in most situations tolerates normal UNIX
files whose lines end with a newline (NL, LF, ^J) only, it seems that the code
that reads in the column names requires a carriage return (CR, ^M) at the
end of the line. When I added a carriage return to the end of the line, making
it CR LF, the above problems went away.

This was deceiving, because newline only files work fine in all other cases
that I have tried.

Test cases: I attach these to mail I have sent to Origin.

I post to this newsgroup in the hope of helping others avoid such problems.

1   L A T E S T    R E P L I E S    (Newest First)
a_user Posted - 08/19/1998 : 5:10:00 PM
ASCII Import routines

The Origin ASCII Import routines are powerful and flexible and compare favorably to many other software packages. While any ASCII file is "legitimate", our "intelligent" import routine sometimes needs some extra help from the user. (I too hesitate to call any software "intelligent" and certainly don't expect it will ever be psychic.)
For the example ASCII file you provided, I opened the File:Import:ASCII Options dialog and set the following options:

Delimited CHECK
Delimiter Tab
Automatic determination of column types UNCHECKED
Skip main header, number of lines 1
Specify known subheader lines CHECKED (number = 0)
# of Columns CHECKED (value = 6)

Origin imports the data completely without modifying the original data file. Once the data has been imported, you can save the worksheet as a template (select File:Save Template As.. from the main menu and save the template with an appropriate name). Any time you need to import data in this file format, choose File:New from the menu, select Worksheet for the Window Type and select the template. You can just select File:Import:ASCII from the menu since the template remembers the appropriate settings.

For files that stubbornly resist importing, our Origin 5.0 Professional package lets you write custom routines that can read (or write) any format you can define.


The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000