Exporting numbers into .tab file

[JariV]

Hi,

I'm exporting data into a .tab file. For some reason, number fields don't get exported correctly, for example 3800 becomes 38 00, 170 becomes 1 70 etc. (there is additional space after hundreds)

There is no extra output formatting selected in the output format options window.

Any ideas what might be causing this?

JariV

[Raybaudi]

That seems impossible.

Try to reproduce that behavior and post the file.

[Vaughan]

Are you opening the .tab file in a text editor, or in Excel?

Excel will "convert" text files automatically, without prompting. It usually shows up as strings with numbers in them converted to dates randomly.

Open the file in Note Pad (windows).

[JariV]

I opened the file in Notepad and in Excel, both showed the same.

After examining the data in Filemaker closer, I think the problem is actually in the data in those fields. In Filemaker the data appeared to be correct (formatting looked ok, calculations worked), but when I manually re-entered the existing value in the field, the additional space in the exported file disappeared.

The data, that I was exporting, was imported from a runtime solution, that was used in South America. Would it be possible, that due to some Windows regional settings etc., some invisible characters were added into those numbers?

JariV