Standardize TMC in NAVSTREETS
1. Add Field – ‘ROAD_DIR’ (text, length 1)
1. Field Calculator
1.LEFT( [TRAFFIC_CD],1)
2.‘OK’
2. Field Calculator – Standardize Road Direction
1. replace([ROAD_DIR], "-", "T")
2. replace([ROAD_DIR], "+", "F")
3. Add Field – ‘TMC’ (text, length 9)
1. Field Calculator
1. right( [TRAFFIC_CD],9)
2. ‘OK’
2. Field Calculator (Standardized Positive/Negative Direction)
1. replace([TMC],"-","N")
2. replace([TMC],"+","P")
Updated 8 days ago