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
 Importing data from csv file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ujin1111

1 Posts

Posted - 10/21/2011 :  05:38:35 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): Origin 8.5.1 Pro
Operating System:Windows XP
Hello!
I've got one problem, using origin 8.5.1. When I'm trying to import data from csv file to origin project with drag&drop, it replaces zero data points to the "." and recognizes it as text. In older version it have been replaced to the 0. How can I fix it in my version of origin?

Drbobshepherd

USA
Posts

Posted - 10/21/2011 :  10:58:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Your csv import filter is probably inserting an ellipse, which is a text string like "-" or "--", into cells with missing data points. You can try writing a LabTalk script in the Advanced Filter Options window to search and replace the ellipses with zeroes. But first, you may have to change the column data types from Text&Numeric to plain Numeric (so your zeroes will be numeric not text). Good luck.
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