Support 805.461.7300
Sales
Our Technology. Your Success.

Create a CSV of your Data Structure with field lengths

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:

=SeqStructure(DBF())

You can also add one or two more parameters to output a different file type (other than CSV) and certain field names. This outputs the result to Fixed Length.

=SeqStructure(DBF(),"TYPE SDF")

Change to TAB using: TYPE DELIMITED WITH TAB

=SeqStructure(DBF(),"TYPE DELIMITED WITH TAB")

The third parameter can control which field attributes get output:

  • These are all the possible output field attributes
  • You can remove which ever fields you want, and the preceding comma
=SeqStructure(DBF(),"TYPE SDF"," FIELDS field_name,field_type,field_len,start,end")

« Back to Commands

I have been working in pretty much all areas of senior-level IT and Data Processing for many years and have had countless hours of experience engaging with customer support. I’ve never had better support than what I receive from Accuzip! Seriously, any time I call, email, or go to the online chat, someone responds in less than a minute, is always very patient and pleasant, and resolves my issue quickly. Aside from just fixing the problem, your support team always takes the time to explain what the problem was and how to prevent it. It is very refreshing and encouraging to see that real support still exists. Thanks to the Accuzip Team!  I look forward to many more years of engagement with your Team.
M.M., Scottsdale, AZ