thanhleviet
7/6/2012 - 7:42 AM

Field calculator to search and replace string field.

Field calculator to search and replace string field.

SearchAndReplace
content_copyfile_download
def SearchAndReplace(field):
    global giatri
    if field.find("Huyện") <> -1:
        giatri= field.replace("Huyện","H.")
    elif field.find("Huyên") <> -1:
        giatri =field.replace("Huyên","H.")
    elif field.find("Thị Xã") <> -1:
        giatri= field.replace("Thị Xã","TX.")
    elif field.find("Thị xã") <> -1:
        giatri= field.replace("Thị xã","TX.")
    elif field.find("Thị Trấn") <> -1:
        giatri= field.replace("Thị trấn","TT.")
    elif field.find("Thành Phố") <> -1:
        giatri= field.replace("Thành Phố","TP.")
    elif field.find("Thành phố") <> -1:
        giatri= field.replace("Thành phố","TP.")
    elif field.find("Quận") <> -1:
        giatri= field.replace("Quận","Q.")
    else:
        giatri = field
    return giatri