| T O P I C R E V I E W |
| ujin1111 |
Posted - 10/21/2011 : 05:38:35 AM
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? |
| 1 L A T E S T R E P L I E S (Newest First) |
| Drbobshepherd |
Posted - 10/21/2011 : 10:58:23 AM
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. |
|
|
