Originally posted by: SystemAdmin

Hi,

The input file I have has data surrounded by double quote (").

example: "INS" (the field size is variable).

The output needs to be without double quote.

example: INS

I can't use substitute because substitute function does not allow to code """ as the replacement field. (=substitute (A, """, "") this one does not work. can't get off the mapping rule.

Do you know what function I can do to get rid of the double quote?

Thanks.

Huong
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Never mind. I found the way to code it. Using Hextexttostream.

Thanks for reading.

Huong :-)
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Congrats on solving your problem. There are other approaches as well. One is to define the element in the input type tree as having quotes in the initiator and terminators. Another approach might have been to use the LEAVEALHPANUM function.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Just one more thing, one can use the SUBSTITUTE function with quotes by combining it with the SYBOL function. SUBSTITUE( ELEMENT, SYMBOL(34), "")
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender