IC95724: FILESOURCE OPERATOR EXPECTS ESCAPE CHARACTER FOR EMBEDDED QUOTATION MARKS IN CSV FORMAT

 

APAR status

  • Closed as fixed if next.

Error description

  • You can use the FileSource operator to read data from a file
    with comma-separated or character-separated values (CSV). The
    operator expects the file to be structured as a series of lines,
     where each line is a list of comma-separated values. If one of
    the values is a string literal that contains embedded double
    quotation marks, the operator expects the embedded quotation
    marks to be prefixed with an escape character.
    For example, a CSV file that contains the following line is
    acceptable:
    Mary \"\"Quite Contrary\"\" Mason",Accountant,Finance,105000.26
    The following line would cause problems:
    Mary ""Quite Contrary"" Mason,Accountant,Finance,105000.26
    An example  error message is as follows:
    09 Oct 2013 16:55:19.861 [32509] ERROR
    #splapptrc,J[0],P[0],Src,spl_operator
    M[Src.cpp:processOneFile:162]  - CDISR5029E: During the read of
    tuple number 1, the , character was expected, but the "
    character was found.
    

Local fix

  • You can work around the problem by modifying the CSV file to
    contain the escape characters before you submit the file to the
    FileSource operator.
    

Problem summary

  • USERS AFFECTED: Users who have embedded quotation marks in CSV
    files that are submitted to FileSource operators.
    PROBLEM DESCRIPTION: See Error Description.
    PROBLEM CONCLUSION: A fix for this issue might be delivered in a
    future release.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC95724

  • Reported component name

    INFOSPHERE STRE

  • Reported component ID

    5724Y95IS

  • Reported release

    310

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-04

  • Closed date

    2013-10-09

  • Last modified date

    2013-10-15

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R310 PSY

       UP

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Streams

Software version:

3.1

Reference #:

IC95724

Modified date:

2013-10-15

Translate my page

Machine Translation

Content navigation