Controls

Re: translate function

Jimmy — Fri, 28 Jan 2011 13:43:58 GMT

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?

Re: translate function

ErnestoM — Fri, 28 Jan 2011 12:38:27 GMT

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

I did manage to get something similar working:

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

translate function

Marzipan — Wed, 26 Jan 2011 18:40:02 GMT

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

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

the result is both ;; are striped.