Example One

This Text File holds address records.

It is a flat, comma delimited, enclosed file with a header, without a type record.

It has 1 List and 1 Condition.

The Schema File has all fields, even though they might be empty (Base.[Field Presence]), but it does not have trailing delimiters (Base.[Trailing Delimiters]). It also has all of the Record Records before all of the Field Records (Base.[Record Order]).

Sample Source File

"first_name","last_name","company_name","address","city","county","postal","phone1","phone2","email","web"
"Britanni","Cunningham","Lacinia Orci Consectetuer LLP","P.O. Box 774, 8282 Turpis Avenue","Stafford","ST","ZW3O 8ZJ","09289 017401","06414 366906","dolor@vulputateeu.com","https://www.vulputateeu.com"
"Hannah","Wilkinson","Et Ultrices Posuere Inc.","Ap #906-6949 Auctor Street","Dunoon","Argyllshire","HB4T 5OO","07933 003360","05181 738428","vehicula@milacinia.net","https://www.milacinia.net"
"Baxter","Romero","Nec Metus Facilisis LLP","421-1637 Primis St.","Paignton","DE","T5M 0QV","01700 455562","07294 797335","libero.Integer.in@odioPhasellus.org","https://www.odiophasellus.org"
"Hamish","Hickman","Dictum Augue Corporation","P.O. Box 369, 5088 Porttitor St.","Derby","Derbyshire","S12 0KT","00805 744232","03480 621329","convallis.in.cursus@sitametconsectetuer.edu","https://www.sitametconsectetuer.edu"
"Katelyn","Fleming","Ut Inc.","8818 Luctus St.","Eyemouth","BE","WU17 3KS","03367 735545","08571 408108","nunc@dolor.co.uk","https://www.dolor.co.uk"
"May","Joseph","Mollis Institute","P.O. Box 708, 2932 Et St.","Aberystwyth","Cardiganshire","YW58 5DD","04505 622973","03736 785797","quis@natoque.edu","https://www.natoque.edu"
"Raja","Roman","Aliquam Iaculis Foundation","P.O. Box 942, 7220 Maecenas Road","Baltasound","SH","KS8Y 4JY","02064 424867","06875 995734","vel.quam.dignissim@aliquet.net","https://www.aliquet.net"
"Walker","Gutierrez","Nec Urna Suscipit Limited","503-2628 Velit Av.","Wakefield","Yorkshire","I3H 5JT","06204 133896","02333 272858","commodo@egestasFusce.com","https://www.egestasfusce.com"

Text File Schema Definition

Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22
Type=META,ID=2,Name=UK-500,Annotation=,Version=20170613,FileType=DELIMITED,DelimiterCharacter=2C,EnclosureCharacter=22,EncloseWhen=ALWAYS,CharacterEncoding=UTF-8,EndOfLine=NEWLINE,FieldIDMethod=HEADER,SchemaURL=,OwnerName=,OwnerEmail=,OwnerPhone=
Type=RECORD,ID=3,Name=Header Row,Annotation=,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=1,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=1,Width=,IsHeader=YES,TrailingDelimiter=
Type=RECORD,ID=4,Name=Data Rows,Annotation=,Position=2,ParentID=2,Required=NO,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=,Width=,IsHeader=NO,TrailingDelimiter=
Type=FIELD,ID=5,Name=First Name Header,Annotation=,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^first_name$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=6,Name=Last Name Header,Annotation=,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^last_name$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=7,Name=Company Name Header,Annotation=,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^company_name$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=8,Name=Address Header,Annotation=,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^address$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=9,Name=City Header,Annotation=,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^city$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=10,Name=County Header,Annotation=,Position=6,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^county$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=11,Name=Postal Header,Annotation=,Position=7,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^postal$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=12,Name=Phone1 Header,Annotation=,Position=8,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^phone1$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=13,Name=Phone2 Header,Annotation=,Position=9,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^phone2$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=14,Name=Email Header,Annotation=,Position=10,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^email$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=15,Name=Web Header,Annotation=,Position=11,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^web$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=16,Name=First Name,Annotation=,Position=1,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=17,Name=Last Name,Annotation=,Position=2,ParentID=4,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=18,Name=Company Name,Annotation=,Position=3,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=19,Name=Address,Annotation=,Position=4,ParentID=4,Required=YES,HasData=CONDITIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=20,Name=City,Annotation=,Position=5,ParentID=4,Required=YES,HasData=CONDITIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=21,Name=County,Annotation=,Position=6,ParentID=4,Required=YES,HasData=CONDITIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=22,Name=Postal,Annotation=,Position=7,ParentID=4,Required=YES,HasData=CONDITIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=23,Name=Phone1,Annotation=,Position=8,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=24,Name=Phone2,Annotation=,Position=9,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=25,Name=Email,Annotation=,Position=10,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=26,Name=Web,Annotation=,Position=11,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=LIST,ID=27,Name=Company Address Condition List,Annotation=,Position=1
Type=VALUE,ID=28,Name=,Annotation=,Position=1,ParentID=27,Value=19
Type=VALUE,ID=29,Name=,Annotation=,Position=2,ParentID=27,Value=20
Type=VALUE,ID=30,Name=,Annotation=,Position=3,ParentID=27,Value=21
Type=VALUE,ID=31,Name=,Annotation=,Position=4,ParentID=27,Value=22
Type=CONDITION,ID=32,Name=Company Address Condition,Annotation=,Position=1,Level=FIELD,ConditionType=PAIRED,ListID=27
Type=SUMMARY,ID=33,ControlCount=1,MetaCount=1,RecordCount=2,FieldCount=22,ListCount=1,ValueCount=4,ConditionCount=1,RuleCount=0,SummaryCount=1,TotalCount=33