| T O P I C R E V I E W |
| neutronguy |
Posted - 08/20/2003 : 06:20:26 AM
Hi, I have an urgent problem.
I need to convert some files and I have tried in Origin. I have to use the files in some unix programs. The problem that numbers with comma is not properly read in the other programs and I want the numbers to be with dots instead of comma, ie. to have the form 0.001 instead of 0,001 when I export them from Origin. What can I do? I have tried in the option but no success. |
| 2 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 08/20/2003 : 3:38:31 PM
If you have your Regional Settings (in Control Panel) set to use comma (,) for your decimal separator, you can leave your Regional Setting alone AND still get Origin to do what you want.
Select : Tools Options from the menu and click on the Numeric Format tab. Change the Separators drop-down list from "Window Settings" to "1,000.0" and click OK.
You will need to refresh your worksheet (Window : Refresh) to see the change. Note that although we specified "1,000.0", which uses commas as thousands separators, commas will not appear unless you set Worksheet Column Format to Display "Decimal 1,000.0". After exporting your data, you can restore the setting.
This can be done programmatically, such that the change is made, the data is exported, and the old settings are restored all with this script:
temp=system.numeric.separators;
system.numeric.separators=1;
doc -uw;
run.section(file,ASCIIExport);
system.numeric.separators=temp;
doc -uw;
Make sure your worksheet is the active window when you run the script.
|
| Mike Buess |
Posted - 08/20/2003 : 3:22:16 PM
The system.numeric.separators property can be used to change the decimal character if Origin recognizes the cell values as numbers rather than text to begin with. If that doesn't work you could just open the file in a simple text editor and Find&Replace all commas with dots. Some text editors (like Notepad) can't read UNIX files. NoteTab Light can read UNIX files, is free and has a "Replace All" button that will surely be useful in your case.
Mike Buess
Origin WebRing Member |
|
|
