AnsweredAssumed Answered

file layout provided in excel using starting and ending field positions

Question asked by jkilgore on Jan 26, 2017
Latest reply on Jan 26, 2017 by siplus

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

 

jfk

Outcomes