Need to manually strip newlines

[frekw]

Given the current input data

id,joke
1,"What did the bartender say to the jumper cables? You better not try to start anything."
2,"Don't you hate jokes about German sausage? They're the wurst!"
3,"Two artists had an art contest... It ended in a draw"
4,"Why did the chicken cross the playground? To get to the other slide."
5,"What gun do you use to hunt a moose? A moosecut!"
6,"If life gives you melons, you might have dyslexia."
7,"Broken pencils... ...are pointless."
8,"What did one snowman say to the other snowman? 'Do you smell carrots?'"
9,"How many hipsters does it take to change a lightbulb? It's a really obscure number. You've probably never heard of it."
10,"Where do sick boats go? The dock!"

The follwing fails

File.stream!("priv/jokes.csv")
|> Stream.take(10)
|> CSV.decode(headers: true, preprocessor: :lines)

with

{:error,
 "Stray quote on line 1 near \"What did the bartender say to the jumper cables? You better not try to start anything.\""}

Due to the string being parsed becoming: "1,\"What did the bartender say to the jumper cables? You better not try to start anything.\"\n". The \n makes it fail, which I would have expected the library to handle out of the box.

No funny encoding is going on:

file priv/jokes.csv
priv/jokes.csv: ASCII text, with CRLF line terminators

In order to fix it I had to manually strip the newlines, like so:

File.stream!("priv/jokes.csv")
|> Stream.map(fn x -> String.trim(x) end)
|> Stream.take(10)
|> CSV.decode(headers: true, preprocessor: :lines)

Is this intended behaviour?

[beatrichartz]

Thanks for raising this, this is indeed not intended behavior. A fix has been released in 2.3.1, can you update and give it a try?