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

CSV Input, Text File Input steps does not work when using the caret(^) as enclosure.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: Urgent
    • Resolution: Unresolved
    • Affects Version/s: 8.3.0 GA, 9.1.0 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      0
    • 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.
    • Steps to Reproduce:
      Hide

      Use the attached sample transformation and sample data to replicate the issue.

      Show
      Use the attached sample transformation and sample data to replicate the issue.

      Description

      When trying to read CSV/Txt file having fields enclosed in caret(^) using the CSV Input or Text File Input step, the fields are not read incorrectly.
      Refer to the screenshot attached.

      If we remove the enclosure and try to get the fields then the values get enclosed within caret, Refer to the screenshot below:

      Attaching the sample data and transformation to replicate the issue

      The issue is same in Text File Input Step.

        Attachments

        1. 101836Sample.zip
          3 kB
        2. csvinput_preview.PNG
          csvinput_preview.PNG
          35 kB
        3. csvinput.PNG
          csvinput.PNG
          27 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            gdev Gurudev
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: