2 Replies Latest reply on Oct 8, 2014 9:48 AM by pbeyrouty

    Import is Evaluating 10e mathematically

    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.