If you are using an Xlate simply copy the fifth component to the first component and copy @null to the fifth component (if using BULKCOPY or PATHCOPY). As a result the Xlate will suppress what now become trailing carets.
I.E. ob field |^^^^data| <---before copies (if using BULKCOPY or PATHCOPY otherwise ib field looks like that)
COPY
0(0)….field(0).[4] 0(0)….field(0).[0] Field now looks like: |data^^^^data|
COPY <--- this COPY is unnecessary if not using BULKCOPY or PATHCOPY
@null (0)….field(0).[4] Field now: |data^^^^| but… since the Xlate gets rid of nonsensical separators really will output like this: |data|.
I think that is what you want.
Jim Kosloskey
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.