Skip to page body Home About Community Living Doing Business Browse by Topic I Want to... Your Government

Minnesota Office of the Secretary of State

To view samples of actual formats, click on the acronym for the format you wish to view.

FXCSFixed Character Position Trailing  Spaces Included
TFCFixed Character Position, Tabset Separated, Trailing Spaces Truncated
CSQComma Separated Enclosed In Quotes
The UCC image database is available on CD-ROM in a TIF format (compressed). 

For further information or to place your email on our distribution list, please contact us at  UCC.Dept@state.mn.us

UCC and Business Services Product Formats 

In the following examples, the bold numbers at the top and the plus sign at the end are not in the actual data received. The bold numbers across the top are use in the example to show the field sizes by showing the column positions. The plus at the end, is used to show where the record line ends. In computer language, this would be a carriage return and line feed.

The following example shows how a FXC format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a space in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are removed. This saves some space on the media that it is written to, however, if a program expects that the file should have 71 characters, it will fail when it only gets 69 or 70.

                     11111111112222222222333333333344444444445555555555666666666677
12345678901234567890123456789012345678901234567890123456789012345678901
01973 005      735             763              BRIGHTON       ST+
01974 005      505           1003              BRISBIN            ST+
05357 005      700             710              BRYANT            AVE+
01983 005     3303          3357               BRYANT            AVE+
01984 005     3503          3649               BRYANT            AVE+
01985 005     3700          3750               BRYANT            CIR+

The following example shows how a FXCS format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a space in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are kept in the file. This takes more space on the media that it is written to, but it guarantees that all records have 71 characters.

                     11111111112222222222333333333344444444445555555555666666666677
12345678901234567890123456789012345678901234567890123456789012345678901

01973 005      735            763                BRIGHTON      ST    +
01974 005      505          1003                BRISBIN           ST    +
05357 005      700            710                BRYANT           AVE  +
01983 005     3303          3357               BRYANT           AVE  +
01984 005     3503          3649               BRYANT           AVE  +
01985 005     3700          3750               BRYANT           CIR   +

The following example shows how a TFC format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a Tab Set in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are removed. This saves some space on the media that it is written to, however, if a program expects that the file should have 71 characters, it will fail when it only gets 69 or 70.

                     11111111112222222222333333333344444444445555555555666666666677
12345678901234567890123456789012345678901234567890123456789012345678901

01973 005      735            763               BRIGHTON      ST+
01974 005      505          1003               BRISBIN           ST+
05357 005      700            710               BRYANT           AVE+
01983 005     3303          3357               BRYANT           AVE+
01984 005     3503          3649               BRYANT           AVE+
01985 005     3700          3750               BRYANT           CIR+  

The following example shows how a TFCS format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a Tab Set in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are kept in the file. This takes more space on the media that it is written to, but it guarantees that all records have 71 characters.

                     11111111112222222222333333333344444444445555555555666666666677
12345678901234567890123456789012345678901234567890123456789012345678901

01973 005      735            763               BRIGHTON       ST  +
01974 005      505          1003               BRISBIN            ST  +
05357 005      700            710               BRYANT           AVE +
01983 005     3303          3357               BRYANT           AVE +
01984 005     3503          3649               BRYANT           AVE +
01985 005     3700          3750               BRYANT           CIR +

The following example shows how a CS format would appear. As you see in all the fields, the spaces at the end are removed. This saves a lot of space on the media that it is written to, however, if the data fields could have commas in them, this could throw of the count of fields per record.

                     11111111112222222222333333333344444444445555555555666666666677
12345678901234567890123456789012345678901234567890123456789012345678901

01973,005,735,763,BRIGHTON,ST+
01974,005,505,1003,BRISBIN,ST+
05357,005,700,710,BRYANT,AVE+
01983,005,3303,3357,BRYANT,AVE+
01984,005,3503,3649,BRYANT,AVE+
01985,005,3700,3750,BRYANT,CIR+

The following example shows how a CSQ format would appear. As you see in all the fields, the spaces at the end are removed and quotes surround the field. This takes up more space than the CS format, but still saves a lot of space on the media that it is written to. This method identifies the fields no matter what characters are in the field (the odds that a field would have a quote and a comma right after it is small).

                    11111111112222222222333333333344444444445555555555666666666677
12345678901234567890123456789012345678901234567890123456789012345678901

“01973”,”005”,”735”,”763”,”BRIGHTON”,”ST”+
“01974”,”005”,”505”,”1003”,”BRISBIN”,”ST”+
“05357”,”005”,”700”,”710”,”BRYANT”,”AVE”+
“01983”,”005”,”3303”,”3357”,”BRYANT”,”AVE”+
“01984”,”005”,”3503”,”3649”,”BRYANT”,”AVE”+
“01985”,”005”,”3700”,”3750”,”BRYANT”,”CIR”+

TIF (TIFF) specifies the file format in which the scanned image is stored.  There is an associated index file for these images. The format of the index has not been determined at this time.

Last updated: 6/19/2012 3:56:49 PM