Support 805.461.7300
Sales 800.233.0555
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 just wanted to take a moment and let you know what an asset Donna Tackett is to your organization. I can not tell you how many times she has helped me understand direct mail as well as the software. She has definitely become my “go to “ person when it comes to doing a mailing. Always professional and personable, I can’t brag about her enough.
B.S., Fayetteville, NC