airboat
Technical User
- Apr 12, 2011
- 17
I would like to make a query that can handle the following:
I have a field called TVCName. In that field field there are many values that all have the same format:
MILWAUKEE, CITY OF
GERMANTOWN, VILLAGE OF
WINTER, TOWN OF
And so on... This is what I need to do. If the field Contains the text TOWN I would like to replace the value of a field called TYPECITY with "TOWN OF" and the value of TVCName before the comma. Another condition I would be running would be if the field TVCName contains the value VILLAGE, I would like to replace the field TYPECITY with "VILLAGE OF" and the value of TVCName before the Comma.
So my field TYPECITY would contain
CITY OF MILWAUKEE
VILLAGE OF GERMANTOWN
TOWN OF WINTER
Thanks in advance for any help.
Heather
I have a field called TVCName. In that field field there are many values that all have the same format:
MILWAUKEE, CITY OF
GERMANTOWN, VILLAGE OF
WINTER, TOWN OF
And so on... This is what I need to do. If the field Contains the text TOWN I would like to replace the value of a field called TYPECITY with "TOWN OF" and the value of TVCName before the comma. Another condition I would be running would be if the field TVCName contains the value VILLAGE, I would like to replace the field TYPECITY with "VILLAGE OF" and the value of TVCName before the Comma.
So my field TYPECITY would contain
CITY OF MILWAUKEE
VILLAGE OF GERMANTOWN
TOWN OF WINTER
Thanks in advance for any help.
Heather