2 Replies Latest reply on Dec 1, 2016 1:57 PM by TSGal

    FM15 : Import Record from xlsx

    kvl_al

      Product and version : 15.0 v2 Pro / Pro Advanced v2

       

      OS and version : all supported

       

      Hardware : Apple / Windows

       

      Description : Import Record from xlsx from a text cell to a text field in FileMaker, convert data into number. (with or not option add table)

       

      How to replicate :

       

      Os regional settings is in french with decimal separator ","

       

      in the same import step :

       

      if you have 12345-3564 you obtain 12345-3564 if you have text you obtain text ok

      if you have 012345.1234 you obtain 012345.1234 if you have text you obtain text ok

      if you have 12.345.1234 you obtain 12.345.1234 if you have text you obtain text ok

      if you have 12345.1234 you obtain 12345,1234 if you have text you obtain number Nok