Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592

    Looking for reference document.

    I'm getting an export file of VSAM data from a vendor in what is supposed to be comma-separate format with quoted strings. But the data contains a text field that itself contains quotes, single quotes, commas, carriage returns, etc.
    So of course it is not parsing correctly.
    Does anyone know of a document online that has accepted standards for forming quoted strings? I would like to be able to point the vendor towards it, so they can generate something I can use.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    May 2008
    Posts
    277
    RFC 4180 - Common Format and MIME Type for Comma-Separated Values (CSV) Files

    Generally, fields containing commas, newlines, or double quotes must be enclosed in double quotes, otherwise they're optional. Double quotes are themselves escaped with another set of double-quotes. However, there really isn't a formal specification, so the exact format may differ, though certainly it should be consistent within a document.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Excellent.
    Bookmarked.

    Thanks!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •