I have the situation whereby I am displaying an address in an XForm, this address comes to me pre formatted, but occasionally contains a couple of trailing commas, which I need to remove.
Here is my code:
<xf:output id="Address-control" ref="$Address" >
<xf:label>GP Address</xf:label>
</xf:output>
Which, sometimes produces output like this:
My House, My Road, My Town, , , , ,
I need something to strip out the trailing commas so the output becomes:
My House, My Road, My Town
Thanks In Advance
Using replace($Address, '[\s,]+$', '')
should remove any trailing mix of white space and commas.