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
 import ascii problem in Origin 7
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

smirnov

Andorra
2 Posts

Posted - 07/08/2003 :  02:53:18 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello,

I've faced with the problem (in Origin 7 only):
When I try to import the following type of ascii table
0 100.000 2.8854E7 -0.03812
8 304.11525 2.8855E7 0.365
10 303.55541 2.88505E7 0.39237
12 303.42469 2.8857E7 0.43192
14 303.06681 2.8862E7 0.47742
16 303.26601 2.8861E7 0.55115
18 303.8537 2.8861E7 0.62658
20 -------- -------- -------- 0.51364 2.8868E7 49.76775
18 -------- -------- -------- 275.70519 2.8869E7 49.713
16 -------- -------- -------- 276.0369 2.88625E7 49.713
14 -------- -------- -------- 274.69407 2.88635E7 49.786
12 -------- -------- -------- 275.96704 2.88545E7 49.786
10 -------- -------- -------- 274.62397 2.8859E7 49.786

- only first 4 columns enter into the Origin worksheet;
When I change Ascii Options import ("when non-numeric is found..") to "read as missing data" Origin deletes non-numeric cells and the rows are shifted up - it's not suitable for me. When I change the option to "start new worksheet/column" it opens second worksheet - it's not suitable too.

I need Origin to properly show my txt table. Can anybody help me?
Thank You.

Edited by - smirnov on 07/08/2003 02:55:11 AM

Edited by - smirnov on 07/08/2003 02:57:47 AM

easwar

USA
1965 Posts

Posted - 07/08/2003 :  10:37:51 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

When you bring up the File Open dialog for ASCII import, select the file, then click on the Options button, and change the following settings:
1> Change "# of columns" radio to first option, and enter 7
2> Specify delimiter to be "space" (I am assuming it is space - I had to cut and paste from the forum which does not support tabs etc - check your delimiter)

Easwar
OriginLab.


Go to Top of Page

bug99

Russia
5 Posts

Posted - 08/02/2003 :  03:20:09 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
There is another way: load text editor and remove '------' regions with 'substitute' command
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