Skip to content

Instantly share code, notes, and snippets.

@dmkoluk

dmkoluk/parseCsv.gs

Forked from simonjamain/parseCsv.gs
Created March 5, 2021 21:52
Show Gist options
  • Save dmkoluk/b30730926daade858768f9296c40c413 to your computer and use it in GitHub Desktop.
Save dmkoluk/b30730926daade858768f9296c40c413 to your computer and use it in GitHub Desktop.
Download ZIP
fix the bug on Utilities.parseCsv() google script function which does not allow newlines in csv strings
Raw
parseCsv.gs
function parseCsv(csvString, delimiter) {
var sanitizedString = csvString.replace(/(["'])(?:(?=(\\?))\2[\s\S])*?\1/g, function(e){return e.replace(/\r?\n|\r/g, ' ') });
return Utilities.parseCsv(sanitizedString, delimiter)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment