Uploaded image for project: 'HPCC'
  1. HPCC
  2. HPCC-3092

Change Request - Detecting Escape Character when spraying delimited files

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.8.2
    • Fix Version/s: 3.10.0
    • Component/s: DFS, ESP
    • Labels:

      Description

      Many tools that export delimited files check the field values for control characters that are otherwise used for field delimiters, text quotes, and record terminators. If a special character is found within a field, an escape character is inserted before the special character.

      Our spray process does not support escape characters. Instead, we currently go back to the source to strip quotes, and add multi-character separators and terminators.

      Enhancing the spray capabilities of the HPCC to support escape characters in field values would be a helpful change.

        Attachments

        1. test.csv
          1 kB
        2. test.sql
          2 kB

          Issue Links

            Activity

              People

              • Assignee:
                rengolin Renato Golin (Inactive)
                Reporter:
                charleskaminski charleskaminski (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: