| Author |
 Topic  |
|
|
XRayD
Germany
Posts |
 Posted - 02/07/2007 : 09:42:58 AM
|
Hi,
I know I'm definitely no expert in origin, but I keep trying. More than once I have encountered problems while importing data from other files (.xls, .txt)
Origin does not correctly recognize separators (in Germany, commas are used to separate integers from fractions of whole numbers instead of points). I've even substituted all commas for points in a .txt file consisting of two colums of data with a header, unfortunately with no effect. If I use the Multiple ASCII-import all data up to < 1.0 were transferred correctly. For all numbers equal or larger than 1.0 separators were ignored or viewed as a thousand-separator.
Can you help me find a solution for this problem?
Thank you very much!
Origin Version (Select Help-->About Origin): 7.5G
Operating System: Windows XP |
|
|
Deanna
China
Posts |
Posted - 02/07/2007 : 9:06:25 PM
|
Hi.
Please use the Options dialog to specify the numeric separator before the importing. You can do it like follows:
1. From the Origin menu, choose Tools: Options.
2. In the Options dialog box, click the Numeric Format tab. Then use the Separators drop-down list to choose 1.000,0, which should be the numeric separator formatting used in German.
3. Click ok to close the dialog. When Origin asks you whether you want to save the changes as the startup setting. Please click yes.
After this, please use the Import Wizard to import the files. The Import Wizard usually handles headers and separators better than the general Import ASCII method. You may find some information about the Import Wizard in your help file.
I hope this will be helpful.
Deanna
OriginLab Technical Services |
 |
|
|
additive
Germany
109 Posts |
Posted - 02/08/2007 : 03:14:45 AM
|
Hallo;
as Deanna pointed out, it's better to use Import Wizard, even for multiple files (just select multiple and they are imported at once). On German OS, number format should be ok. Origin's default setting is "Windows Setting" thus it uses your country setting from Control Panel.
You can contact local tech support at +49-6172-5905-20 or support@additive-net.de to discuss details, you can also provide some sample files for us to test.
Cheers - Ralf
PS: The numeric seperator setting direct in Import Wizard is on the list of "desired features" for any upcoming release... |
|
|
| |
Topic |
|
|
|
which separator is needed for successful import ?