Guides
Guides

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")
Standardize TMC in FGDB