There is a field which finishes with a CR character (/n).
Following options were tried, but didn't work.
1) Tried the following function Trim(FIELD,'/n', 'B'), but it doesn't work.
2)Tried to use the Char function in order to retrieve the CR from its ASCII code and trim it after (Trimb(Trimf(Trim(NullToValue(SR_2_TR.OPCUA2,''),Char(13),'T')))) but it doesn't work too.
Finally, what worked -
Using Convert function in Transformer. Convert Char(13) and Char(10) in the input string to ‘’.
Following options were tried, but didn't work.
1) Tried the following function Trim(FIELD,'/n', 'B'), but it doesn't work.
2)Tried to use the Char function in order to retrieve the CR from its ASCII code and trim it after (Trimb(Trimf(Trim(NullToValue(SR_2_TR.OPCUA2,''),Char(13),'T')))) but it doesn't work too.
Finally, what worked -
Using Convert function in Transformer. Convert Char(13) and Char(10) in the input string to ‘’.