Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

In my attribute tables field. I am trying to get rid of the "&" in between names i.e. "John Adams & wife" and want it to say "John Adams and Wife" in all the attributes with "&". What is the VB for that? I can't seem to find it in the help page of ArcGIS.

Thanks

share|improve this question
    
vba and vbscript are different languages. At 10.0 calculator supports vbscript and python. Before 10.0 it supported VBA and vbscript. –  Kirk Kuykendall Sep 28 '11 at 19:23
add comment

1 Answer 1

up vote 12 down vote accepted

Check out the replace function in the calculate field examples. Something like this should do it:

NewString = Replace([comments], "&", "and")
share|improve this answer
2  
Don't forget that doing this outside of an edit session will overwrite without undo. This solution will work right but you should test more complex calculations (on the containing field). –  Brad Nesom Dec 8 '10 at 2:37
    
Thank You, I solved it late last night. I was very close for a while then figured it out. –  Zoran Dec 8 '10 at 17:16
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.