CMS TXT File Layout Example
Header
indexÿrecordDateÿrecordTimeÿdistrictÿlocationNameÿnearbyPlaceÿlongitudeÿlatitudeÿelevationÿdirectionÿcountyÿrouteÿrouteSuffixÿpostmilePrefixÿ postmileÿalignmentÿmilepostÿinserviceÿmessageDateÿmessageTimeÿdisplayÿdisplayTimeÿphase1Fontÿphase1Line1ÿphase1Line2ÿphase1Line3ÿ phase2Fontÿphase2Line1ÿphase2Line2ÿphase2Line3
Data
5ÿ2012-01-12ÿ16:08:00ÿ2ÿ5 - Walters Lane N/B - YrekaÿYrekaÿ-122.635373ÿ41.685655ÿ2805ÿNorthÿSiskiyouÿI-5ÿÿRÿ44.31ÿÿ771.54ÿtrueÿ2012-01-12ÿ06:27:47ÿTwo Pagesÿ3.5ÿSingle Strokeÿ CLICK ITÿORÿTICKETÿSingle StrokeÿSLOWÿFOR THEÿCONE ZONE
Delimeter
ÿ
Layout
| Field Number | TXT Column | Header | Data |
|---|---|---|---|
| 1.1.1 | 1 | index | 5 |
| 1.1.2.1 | 2 | recordDate | 2012-01-12 |
| 1.1.2.2 | 3 | recordTime | 16:08:00 |
| 1.1.3.1 | 4 | district | 2 |
| 1.1.3.2 | 5 | locationName | 5 - Walters Lane N/B - Yreka |
| 1.1.3.3 | 6 | nearbyPlace | Yreka |
| 1.1.3.4 | 7 | longitude | -122.635373 |
| 1.1.3.5 | 8 | latitude | 41.685655 |
| 1.1.3.6 | 9 | elevation | 2805 |
| 1.1.3.7 | 10 | direction | North |
| 1.1.3.8 | 11 | county | Siskiyou |
| 1.1.3.9 | 12 | route | I-5 |
| 1.1.3.10 | 13 | routeSuffix | |
| 1.1.3.11 | 14 | postmilePrefix | R |
| 1.1.3.12 | 15 | postmile | 44.31 |
| 1.1.3.13 | 16 | alignment | |
| 1.1.3.14 | 17 | milepost | 771.54 |
| 1.1.4 | 18 | inService | true |
| 1.1.5.1.1 | 19 | messageDate | 2012-01-12 |
| 1.1.5.1.2 | 20 | messageTime | 06:27:47 |
| 1.1.5.2 | 21 | display | Two Pages |
| 1.1.5.3 | 22 | displayTime | 3.5 |
| 1.1.5.4.1 | 23 | phase1Font | Single Stroke |
| 1.1.5.4.2 | 24 | phase1Line1 | CLICK IT |
| 1.1.5.4.3 | 25 | phase1Line2 | OR |
| 1.1.5.4.4 | 26 | phase1Line3 | TICKET |
| 1.1.5.5.1 | 27 | phase2Font | Single Stroke |
| 1.1.5.5.2 | 28 | phase2Line1 | SLOW |
| 1.1.5.5.3 | 29 | phase2Line2 | FOR THE |
| 1.1.5.5.4 | 30 | phase2Line3 | CONE ZONE |