Standardize TMC in FGDB
1. Add Field – ‘TMC’ (text, length 9)
1. Field Calculator
1. [EBU_COUNTRY_CODE] & right("0"&[LOCATION_TABLE_NR],2) & [TMC_PATH_DIRECTION] & [LOCATION_CODE]
2. Field Calculator
1. replace([TMC], "-", "N")
2. replace([TMC], "+", "P")
Updated 8 days ago