Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-8348

Text File Output step fails round-trip test when decimal separator is used as field separator.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Low
    • Resolution: Incomplete
    • Affects Version/s: 4.3.0 GA (4.5.0 GA Suite Release)
    • Fix Version/s: Backlog
    • Component/s: Step, Transformation
    • Labels:
      None
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      When numbers with decimal places are formatted with a comma as the decimal point, and when the original CSV meta characters (field separator = comma; quote character = double quote) are configured, then TFO will not quote the numbers, thus ruining the file layout. In addition, if a comma is part of a string value and the option "Disable enclosure fix" is selected, another fake output field is generated, again by not quoting the field value properly.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              marabu Achim Richter
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: