Details
-
Bug
-
Resolution: Won't Do
-
Major
-
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