Skip to content

Instantly share code, notes, and snippets.

@simonjamain

simonjamain/parseCsv.gs

Last active April 26, 2022 00:45
Show Gist options
  • Save simonjamain/7e23b898527655609e5ff012f412dd50 to your computer and use it in GitHub Desktop.
Save simonjamain/7e23b898527655609e5ff012f412dd50 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)
}
@TakahisaHayashi
Copy link

Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment