kvl_al

FM15 : Import Record from xlsx

Discussion created by kvl_al on Nov 24, 2016
Latest reply on Dec 1, 2016 by TSGal

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

Outcomes