deleting specific word from a field 1

[goslincm]

I have a field called [Official Name] and in that field are the names of various cities followed by the word CITY. Is there a way to just delete the word city while keeping the name of the city which is to the left of the word city?

 

[DotNetGnat]

Replace(field, 'city','')

-DNG

 

[PHV]

Trim(Left([yourField],InStr([yourField],' CITY')))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[goslincm]

when I typed: Replace(Name, 'city'")

get error indicating: the expression you entered has an invalid string.

 

[goslincm]

Excellent, thanks so much PH

 

[DotNetGnat]

you missed a comma...
but as always PHV suggestion is the best...
-DNG

 

[goslincm]

Actually when I run this query I don't see where a comma is missing, but my results remove the "ity" of the word city, still leaving the "c" out there. How can I get rid of the whole word city? I've tried using both upper and lower case C.

 

[IT4EVR]

Left$([Official Name], InStr([Official Name], "city") - 1)

 

[IT4EVR]

oops, sorry, phv already solved this one

 

[goslincm]

Thank you so much!

 

[PHV]

Seems you missed the space before CITY in my post stamped 28 Jul 06 16:36.