Attached is one way to do it, Yes I would use a table with the correct values. You cloud also write code in a Rule Engine or a Java Snippet but then if you would want to edit something you would have to go thru a lot of code.
example_wrong_city.knwf (21.7 KB)