4

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.

Improve this question
1
  • 1
    vba and vbscript are different languages. At 10.0 calculator supports vbscript and python. Before 10.0 it supported VBA and vbscript. Commented Sep 28, 2011 at 19:23

1 Answer 1

Reset to default
13

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

NewString = Replace([comments], "&", "and")
Improve this answer
2
  • 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). Commented Dec 8, 2010 at 2:37
  • Thank You, I solved it late last night. I was very close for a while then figured it out. Commented Dec 8, 2010 at 17:16

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.