how to concatenate for exemple the first 10 characters of the column [CRIBINV], followed by the entire value of [CRD6002], and then the last 10 characters of [CRIBINV]
In a prepare recipe, by using the formula processor, something like this should work: concat(substring(CRIBINV,0,10),val("CRD6002"), substring(CRIBINV,-10))
