Create Project as CSV with single quotes is detected as TSV

Create Project as CSV with single quotes is detected as TSV

To Reproduce

Steps to reproduce the behavior:

1. Create Project. Choose file. Use CSV data from the three samples below
2. Click Next

Current Results

• CSV with single quotes: detects columns separated by tabs (TSV)

• CSV with double quotes: detects columns separated by commas (CSV)

• CSV with no quotes: detects columns separated by commas (CSV)

Expected Behavior

• CSV with single quotes should be detected as columns separated by commas (CSV)
• Data with single quotes should also use single quotes instead of double quotes to enclose the cell data

Datasets

CSV with single quotes

'NDB_No', 'Shrt_Desc', 'Water', 'Energ_Kcal'
'01001', 'BUTTER,WITH SALT', '1.00', '333'
'01001', 'BUTTER,WITH SALT', '15.87', '717'
'01002', 'BUTTER,WHIPPED,WITH SALT', '15.87', '717'
'01003', 'BUTTER,CREAM', '15.87 oz', '717 oz'

CSV with double quotes

"NDB_No", "Shrt_Desc", "Water", "Energ_Kcal"
"01001", "BUTTER,WITH SALT", "1.00", "333"
"01001", "BUTTER,WITH SALT", "15.87", "717"
"01002", "BUTTER,WHIPPED,WITH SALT", "15.87", "717"
"01003", "BUTTER,CREAM", "15.87 oz", "717 oz"

CSV with no quotes

NDB_No, Shrt_Desc, Water, Energ_Kcal
01001, BUTTER,WITH SALT, 1.00, 333
01001, BUTTER,WITH SALT, 15.87, 717
01002, BUTTER,WHIPPED,WITH SALT, 15.87, 717
01003, BUTTER,CREAM, 15.87 oz, 717 oz

Start by reproducing the issue through Create Project, Choose file, and Next with the three CSV samples in the report. No source file or test is named; done means single-quoted data is detected as comma-separated CSV and retains single quotes when enclosing cell data.