Mike Frost
02-05-2002, 08:27 AM
On some Windows systems, the decimal symbol is set by default to be a comma and not a decimal point. This is common when Windows is installed within regions outside the United States.
Exported file with Comma Decimal Symbol:
<header removed for clarity>
* Frequency(Hz) Magnitude(dB) Phase(Deg)
+1,000000000000E+001, -56,629136, 174,356493
+1,015348871761E+001, -56,365467, 174,270212
<497 data points removed for clarity>
+2,000000000000E+004, -9,376781, -130,260890
The solution is to change the Decimal Symbol to a decimal point. Go to Settings > Control Panel > Regional Settings (Regional Options under WinNT or Win2K; Regional and Langauge Options under WinXP). Select the Numbers tab (Customize > Numbers under WinXP), and change the character in Decimal Symbol to a decimal point.
Exported file with Decimal Point Decimal Symbol:
<header removed for clarity>
* Frequency(Hz) Magnitude(dB) Phase(Deg)
+1.000000000000E+001, -56.629136, 174.356493
+1.015348871761E+001, -56.365467, 174.270212
<497 data points removed for clarity>
+2.000000000000E+004, -9.376781, -130.260890
Exported file with Comma Decimal Symbol:
<header removed for clarity>
* Frequency(Hz) Magnitude(dB) Phase(Deg)
+1,000000000000E+001, -56,629136, 174,356493
+1,015348871761E+001, -56,365467, 174,270212
<497 data points removed for clarity>
+2,000000000000E+004, -9,376781, -130,260890
The solution is to change the Decimal Symbol to a decimal point. Go to Settings > Control Panel > Regional Settings (Regional Options under WinNT or Win2K; Regional and Langauge Options under WinXP). Select the Numbers tab (Customize > Numbers under WinXP), and change the character in Decimal Symbol to a decimal point.
Exported file with Decimal Point Decimal Symbol:
<header removed for clarity>
* Frequency(Hz) Magnitude(dB) Phase(Deg)
+1.000000000000E+001, -56.629136, 174.356493
+1.015348871761E+001, -56.365467, 174.270212
<497 data points removed for clarity>
+2.000000000000E+004, -9.376781, -130.260890