...
Advanced Setup Available: No
File Format: Fixed Length
*Note: Not all fields are defined; only ones we are importing.
| Field | Start Position | Length | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Import.Birthdate | MCDateMask | Trim | Mid | (sLineOfText | 14 | 21 | "MMDDYYYY" | |||
| Import.FirstName | Trim | Mid | (sLineOfText | 24 | 20 | |||||
| Import.LastName | Trim | Mid | (sLineOfText | 44 | 20 | |||||
| Import.Middle | Trim | Mid | (sLineOfText | 64 | 1 | |||||
| Import.Address1 | Trim | Trim | Mid | (sLineOfText | 65 | 5 | & " " & Trim(Trim (Mid (sLineOfText, 70, 20) | |||
| Import.Address2 | Trim | Mid | (sLineOfText | 90 | 20 | |||||
| Import.City | Trim | Mid | (sLineOfText | 110 | 15 | |||||
| Import.State | Trim | Mid | (sLineOfText | 125 | 2 | |||||
| Import.Zip | Trim | Mid | (sLineOfText | 127 | 5 | |||||
| Import.StudentSSN | Trim | Mid | (sLineOfText | 132 | 9 |