developer

Dealing with commas in a CSV file

Question: ❓❓❓ I am looking for suggestions on how to handle a csv file that is being created, then uploaded by our customers, and that may have a comma in a value, like a company name. Some of the ideas we are looking at are: quoted Identifiers (value “,” values Read more…

By admin, ago
developer

Excel to CSV with UTF8 encoding

Question: ❓❓❓ I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the “special” Spanish characters that aren’t ASCII characters. It also seems to Read more…

By admin, ago