AnsweredAssumed Answered

Import is Evaluating 10e mathematically

Question asked by pbeyrouty on Oct 7, 2014
Latest reply on Oct 8, 2014 by pbeyrouty

Summary

Import is Evaluating 10e mathematically

Product

FileMaker Pro

Version

Advanced 13.0v3

Operating system version

Windows 7

Description of the issue

The database I am using does an automatic import from an XLSX file. One of the fields contains a list of IDs that proceed with an alpha numeric pattern. For instance 11d-3, 11d-4, 07s-01, 08s-01, 09s-01, 11s-01, etc. Some of the IDs end up looking like the e in math notation (10e-01, 10e-02, 10e-03, etc). When these rows are imported they are being converted to 1, .1, .01, etc. The field they are being imported to is a text field. Also, they are formatted as text in the Excel file.

Steps to reproduce the problem

Create an XLSX field with a column containing the data below. Import this data into a text field. You will see that all of the items except the last two are converted into number.
10e-01
10e-02
10e-03
10e-04
10e-05
10e-06
10e-07
10e-08
10e-09
10e-10
10e-11
10e-12
10f-01
10f-02

Expected result

10e-01
10e-02
10e-03
10e-04
10e-05
10e-06
10e-07
10e-08
10e-09
10e-10
10e-11
10e-12
10f-01
10f-02

Actual result

1
.1
.01
.001
.0001
.00001
.000001
.0000001
.00000001
.000000001
1.0e-10
1.0e-11
10f-01
10f-02

Workaround

I have altered the script to change those fields back to what they should be after the import.

Outcomes