Download and unzip the seqstructure.zip file into the root level of the AccuZIP6 5.0 folder.
Open any database and run the following command to create a Comma Separated file of the Database Structure with the Start-Stop Character Positions for each field in the database:
Code: Select all
=SeqStructure(DBF())
- This outputs the result to Fixed Length.
Code: Select all
=SeqStructure(DBF(),"TYPE SDF")
Code: Select all
=SeqStructure(DBF(),"TYPE DELIMITED WITH TAB")
- These are all the possible output field attributes
- You can remove which ever fields you want, and the preceding comma
Code: Select all
=SeqStructure(DBF(),"TYPE SDF"," FIELDS field_name,field_type,field_len,start,end")