IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
Back to discussions
Expand all | Collapse all

Embedded quotes in quote delimitd file

  • 1.  Embedded quotes in quote delimitd file

    Posted Thu October 06, 2005 12:51 AM

    Originally posted by: SystemAdmin


    Hi,

    We have a (Parallel extender) job reading data from a DB2 table and writing the selected data to a sequential file (comma separated, double quote delimited).

    A second (Server) job tries to read this file but fails:

    code:1:d72e285f0e[b]nls_read_delimited() - invalid quotes, column VEN_ADDRESS_1 = "LEVEL 2 "[/b][/code:1:d72e285f0e]

    I know that the problem is caused by the embedded double quote character within one of the data columns (for ex. "u:d72e285f0eLEVEL 2 "ABC" [/u:d72e285f0e]").

    Is there a (simple) way of dealing with this problem?

    I can think of 3 options:

    b:d72e285f0e1.[/b:d72e285f0e] use different quote character. But then the question is which character to pick to be sure you don´t run into the same problem.
    b:d72e285f0e2.[/b:d72e285f0e] replace all embedded double quotes by a single quote (or any other character).
    b:d72e285f0e3.[/b:d72e285f0e] create the sequential file as a fixed record type file (so not quote delimited and comma separated).
    Any other ideas on this problem are more than welcome.

    Thanks

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