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 for Programming
 LabTalk Forum
 Importing Ascii files		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

bigfootnj

USA
Posts
Posted - 06/22/2004 :  11:27:05 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
I am writing a script to open and convert multiple Ascii files and I was wondering if anyone knows how to open am ASCII file and save each line of the file as a new string element of a dataset. The lines are short, <25 characters, and are mixed text and numeric. I have tried

open -w %A;

trying to import the file into the active worksheet, but I get an error that my file is not ascii, even though it is. I appreciate any suggestions. Thanks!

bigfootnj

USA
Posts
Posted - 06/22/2004 :  11:50:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I should specify, the error is "File _____ does not seem to consist of columns of Ascii data." What I really want is one big column.
Go to Top of Page

Mike Buess

USA
3037 Posts
Posted - 06/22/2004 :  12:35:35 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Open ASCII Options for the worksheet.

File Structure section...
Select Fixed column widths: 25 (?).
Uncheck all other boxes.

File header section...
Skip main header: 0 lines
Select Specify subheader lines: 0

# of Columns: 1

Other Options...
Uncheck Rename columns
Uncheck Create column labels

...Click Update Options and save as new template. Use that template for future imports.

Mike Buess
Origin WebRing Member

Edited by - Mike Buess on 06/22/2004 12:37:47 PM
Go to Top of Page

bigfootnj

USA
Posts
Posted - 06/22/2004 :  3:01:26 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks! That worked!
Go to Top of Page
  Previous Topic 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