Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2815

Flat File Import - "Parse Selected Row" feature works incorrectly

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • 10.0.2
    • 9.0.6, 10.0.1
    • None
    • None

    Description

      In Empdata.csv, there are data that include "annual salary". This value is entered as "$71,000.00" (for example). If you choose "character delimited" column format, click on some row in File Contents Preview and hit "Parse Selected Row" the values are parsed as:

      ... AnnualSalary: $7, Title: 000.00" ...

      Expected result is:
      ... AnnualSalary: $71,000.00, Title: Associate, ...

      Actually, when you finish the wizard and hit preview on the table (or create a VDB and query the table) the value is parsed correctly. Only the "Parse Selected Row" feature parses the row incorrectly.

      Screenshot attached

      Attachments

        Activity

          People

            blafond Barry LaFond
            mmakovy@redhat.com Matus Makovy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: