Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
@bnickles don’t do that, even without saving Excel can muck up a CSV file. Only use Notepad/Notepad++ or a pure text editor.
-
zymk11506yIIRC excel changes the encoding of csv’s. This has gotten me quite a few times 😅
I just started using vs code with rainbow-csv plugin to make it easier to work with. -
@bkwilliams I often use excel to populate sql insert script in a new col. works every time
-
@sunfishcc that’s fine if you are doing the insert via Excel. What will mess you up is using Excel as a UI for a CSV but doing the import/merge via another process.
CSV wouldn't import to database despite researching problem for the past hour. Fuck it I'm getting drunk
rant