Example Six

This Text File holds product availability records.

It is an untagged, non-flat, comma delimited, partially enclosed file, with a header record, without a type record.

The Schema File has all fields even if they have no value (Base.[Field Presence]), and it has 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

Product Title,Price,Weight,Quantity,Description
Wagyu Tenderloin Steak,,,,"The most decadent, succulent cut of beef, ever."
Wagyu Tenderloin Steak,55 ,6 oz,,
Wagyu Tenderloin Steak,65 ,9 oz,,
Wagyu Tenderloin Steak,79 ,12 oz,,
Lamb Chops,,,,These taste really good.
Lamb Chops,20 ,,3 chops,
Lamb Chops,40 ,,6 chops,
Lamb Chops,60 ,,9 chops,

Text File Schema Definition

Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22,,,,,,,,,,,,,,,,,
Type=META,ID=2,Name=data-example-3,Annotation=,Version=2016-06-16,FileType=DELIMITED,DelimiterCharacter=2C,EnclosureCharacter=22,EncloseWhen=NEEDED,CharacterEncoding=UTF-8,EndOfLine=NEWLINE,FieldIDMethod=HEADER,SchemaURL=,OwnerName=,OwnerEmail=,OwnerPhone=,,,,,
Type=RECORD,ID=3,Name=Header,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=Product,Annotation=,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=,KeyField=,ParentKeyField=,RecordIDPosition=12,RecordIDValue=EMPTY,RecordRow=,Width=,IsHeader=NO,TrailingDelimiter=,,,
Type=RECORD,ID=5,Name=Price,Annotation=,Position=3,ParentID=4,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=,KeyField=16,ParentKeyField=11,RecordIDPosition=17,RecordIDValue=NOT EMPTY,RecordRow=,Width=,IsHeader=NO,TrailingDelimiter=,,,
Type=FIELD,ID=6,Name=Product Title Header,Annotation=,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=7,Name=Price Header,Annotation=,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=8,Name=Weight Header,Annotation=,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=9,Name=Quantity Header,Annotation=,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=10,Name=Description Header,Annotation=,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=11,Name=Product Title Product,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=12,Name=Price Product,Annotation=,Position=2,ParentID=4,Required=YES,HasData=NEVER,MinimumLength=,MaximumLength=,DataType=,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=13,Name=Weight Product,Annotation=,Position=3,ParentID=4,Required=YES,HasData=NEVER,MinimumLength=,MaximumLength=,DataType=,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=14,Name=Quantity Product,Annotation=,Position=4,ParentID=4,Required=YES,HasData=NEVER,MinimumLength=,MaximumLength=,DataType=,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=15,Name=Description Product,Annotation=,Position=5,ParentID=4,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=16,Name=Product Title Price,Annotation=,Position=1,ParentID=5,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=17,Name=Price Price,Annotation=,Position=2,ParentID=5,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=NUMBER,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=18,Name=Weight Price,Annotation=,Position=3,ParentID=5,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=19,Name=Quantity Price,Annotation=,Position=4,ParentID=5,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=20,Name=Description Price,Annotation=,Position=5,ParentID=5,Required=YES,HasData=NEVER,MinimumLength=,MaximumLength=,DataType=,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=SUMMARY,ID=21,ControlCount=1,MetaCount=1,RecordCount=3,FieldCount=15,ListCount=0,ValueCount=0,ConditionCount=0,RuleCount=0,SummaryCount=1,TotalCount=21,,,,,,,