19
TIL that RFC 4180 specifies the CSV format to use CRLF line endings
(datatracker.ietf.org)
Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!
Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.
Hope you enjoy the instance!
Rules
Follow the wormhole through a path of communities !webdev@programming.dev
I hate that the pleasant news about standardization of CSV come with the let-down that is using two bytes for new lines.
Don't worry, it's not really standardised despite this attempt. You can use UNIX line endings and nothing bad will happen.
Unless you open it in Excel. In which case bad things will happen no matter what you have in the CSV…
If I am using Excel, I am using Windows and I will be changing all text to use CR-LF newline format (if sending from a Linux system) anyway.