InfoPath Dev

field2=translate(field2, "';;", ";")

I'm trying to replace double semi-colons with a single semi-colon 

the result is both ;; are striped.

Interesting. translate() won't work for me either.

I did manage to get something similar working:

concat(substring-before(field1, ";;"), ";", substring-after(field1, ";;"))

I'm afraid translate() doesn't work like that.  Translate replaces single characters with other single characters, or it can remove single characters:

http://www.w3.org/TR/xpath/#function-translate

You can probably rig up something with rules and tricky XPath functions, but you risk causing an infinite loop error if there are a lot of double semicolons.  The other alternative is to use code which, can remove them pretty easily.

 Can I ask why your values have these double semicolons in them to begin with?