Create a CSV of your Data Structure with field lengths

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Create a CSV of your Data Structure with field lengths

Post by Eric » Mon Sep 14, 2009 4:01 pm

The following command creates a Comma Separated file of the Database Structure with the Start-Stop Character Positions for each field in the database.

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()) 
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.

Code: Select all

=SeqStructure(DBF(),"TYPE SDF")
Change to TAB using: TYPE DELIMITED WITH TAB

Code: Select all

=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

Code: Select all

=SeqStructure(DBF(),"TYPE SDF"," FIELDS field_name,field_type,field_len,start,end")
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply