As one of the easiest options in creating a Positional Schema is to upload a definition file. Positional schema is a single record type file. Please see the below example of the format of the definition file.
In the list below the fields in record A contain start and end position. But we can also just provide a length, thus for example for Account_No we can put:
A,Account_No,,String,,,,,20,L,F
Record_Type:A
A,Account_No,,String,,,1,20,,L,F
A,Record_Type,,String,,,21,21,,L,F
A,Sequence_Number,,String,,,22,23,,L,F
A,Title,,String,,,24,27,,L,F
A,Customer_Type,,String,,,28,28,,L,F
A,Name,,String,,,29,68,,L,F
A,Account_Addr1,,String,,,69,93,,L,F
A,Account_Addr2,,String,,,94,118,,L,F
A,City,,String,,,119,138,,L,F
A,County,,String,,,139,153,,L,F
A,State,,String,,,154,155,,L,F
A,Zip_Code,,String,,,156,165,,L,F
A,Home_Phone_No,,String,,,166,181,,L,F
A,Work_Phone_No,,String,,,182,197,,L,F
A,Birthdate,,String,,,198,205,,L,F
A,Employers_Name,,String,,,206,245,,L,F
Comments
0 comments
Article is closed for comments.