The parseCsv method of Google Scripts lets you specify a different delimiter so in your case, it is a tab with is written as "\t"
You can replace:
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
with
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString(), "\t");
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString(), "\t");
Darwin Nales
Hi,
There is a great script posted on your website, which allows you to import a CSV file into a Google Sheet. My challenge is that I want to use this script with CSV files that have a 'tab' as a delimiter... not a 'comma'.
I noticed there are some solutions in google scripts to solve this, but I am not there yet to arrange this myself. Could you perhaps support me in adjustting this script to make it work with csv files, which have a tab delimiter?
Already thanks in advance for your support.
Regards,
Darwin