2.3 Cleansing
Cleansing of data requires to be standardizing as per the set spellings approved by TMB. Therefore cleansing is to be done with reference to Master Lookup table which contains correct spelling or way of writing for each of the words occurring in address database. For e.g. Bangkok can be written in many ways such as Bangkok in English, Krung Thep Maha Nakhon in English Transliterate or กรุงเทพมหานคร in Thai or กทม.in Abbreviated Thai. The cleansing of data requires transforming all these into one word as approved by TMB. The cleansing requirement for each of the fields are mentioned below