Skip to content

Instantly share code, notes, and snippets.

@larrybolt

larrybolt/remove-newlines-from-csv-file.sh

Created June 27, 2017 09:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save larrybolt/cb044824c80fc7739a8f611a53b2f0cf to your computer and use it in GitHub Desktop.
Save larrybolt/cb044824c80fc7739a8f611a53b2f0cf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
remove-newlines-from-csv-file.sh
# 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