The below expression in tMap column editor for a particular column will convert string to BigDecimal and replace the "?" mark with empty space .
new BigDecimal(StringHandling.CHANGE("12345?","\\?",""))
:-)
new BigDecimal(StringHandling.CHANGE("12345?","\\?",""))
:-)
No comments:
Post a Comment