6 Replies Latest reply on Jan 26, 2017 12:22 PM by siplus

    file layout provided in excel using starting and ending field positions


      The data file (txt) provided by my vendor is a non-delimited file.  They provide a data dictionary in an Excel file with field name, beginning position, ending position, and data format where each row is a data field.  Is there any way to import this Excel file into FileMaker to build the DB design?  For example, the Excel file looks like this -


      field name    format   beg pos     end pos

      field a              A           1               9

      field b              N.2         10             17

      field c              A             18            30


      There are over 200 data fields so would rather not build from scratch,  Thanks