Skip to content

Instantly share code, notes, and snippets.

@larrybolt
Created June 27, 2017 09:22
Show Gist options
  • Save larrybolt/cb044824c80fc7739a8f611a53b2f0cf to your computer and use it in GitHub Desktop.
Save larrybolt/cb044824c80fc7739a8f611a53b2f0cf to your computer and use it in GitHub Desktop.
# https://stackoverflow.com/questions/2668678/importing-csv-with-line-breaks-in-excel-2007
gawk -v RS='"' 'NR % 2 == 0 { gsub(/\n/, "") } { printf("%s%s", $0, RT) }' input.csv > output.fixed.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment