Here is a tcl that you can pass a field to it and remove the left and right parens from and replace them using the “string map” command:
######################################################################
# Name: tpsremoveparen
# Purpose:
# UPoC type: xltp
# Args: none
# Notes: All data is presented through special variables. The initial
# upvar in this proc provides access to the required variables.
# The expected InVal is a field to remove left and right parens
#
# This proc style only works when called from a code fragment
# within an XLT.
#
proc tpsremoveparen {} {
upvar xlateId xlateId
xlateInList xlateInList
xlateInTypes xlateInTypes
xlateInVals xlateInVals
xlateOutList xlateOutList
xlateOutTypes xlateOutTypes
xlateOutVals xlateOutVals
set fld1 [lindex $xlateInVals 0]
if { [clength $fld1] > 2 } {
set y [string map {( “” ) “”} $fld1]
}
#echo n “range is ” $y
set xlateOutVals “$y”
}