Remove extra spaces with Attribute Assistant

[JoeBorgione]

Lets say a guy has an attribute value that gets entered like this: myfield = "TOO  MANY SPACES" where there are two spaces between TOO & MANY. 

Using the attribute assistant, how would that guy drop the double space and replace it with just one?

[JoeBorgione]

moments later it came to me.  In the dynamic values table, enter a new record accordingly for Table Name, Field Name, Value Method will equal EXPRESSION and Value Info will use the replace function like this:

(Replace[myfield],"  "," "))

If you want to look for additional spaces like three or four, just add a line for each and change the Replace() to reflect the number of spaces

[DanPatterson_Retired]

does attribute assistant use python? (don't have it)  If so check the other thread that you were working on

[JoeBorgione]

No or I would'n have hit the VBs wall...  It's working now; extra spaces were giving me heartburn.