Status: 

Vuo version: 

Fixed in Vuo version: 

OS version: 

  • macOS 11

CPU architecture: 

Intel x86_64

How severely does this bug affect you?: 

●●●○ — It prevents me from completing a specific task with Vuo.

Steps causing the bug to occur: 

  1. Make table in Excel
  2. Export as either of the following: CSV, CSV-UTF8, Tab separated TXT, Macintosh CSV, MS-DOS CSV
  3. Fetch table in Vuo
  4. No items in table

Have you found a workaround?: 

No

Comments

The problem is that Fetch

jstrecker's picture
Submitted by
Status:
Waiting for review by Vuo Support Team
»
Accepted

The problem is that Fetch Table only handles commas and tabs as separators. If, based on your region settings, Excel is using a comma for the decimal point, then exported CSVs will use a semicolon as the column separator.

Thanks for reporting this bug, @MartinusMagneson. We'll modify Fetch Table (and Make Table from Text and Format Table) to correctly handle this case.

If you have the option to format the file differently when exporting from Excel, that would be one workaround. Or you could do a quick-and-dirty search-and-replace as in the attached composition (which wouldn't correctly handle quoted/escaped separators).