I am reading a few thousand csv files where some columns have a very 'interesting' format: {""Q0"":""double double quote""}
It seems read.csv
reads it fine, but both read_csv
and fread
are doing different things (see below). My expectation would be to have: {"Q0":"double double quote"}
Is this a bug or am I doing something wrong?
# Content of csv file
# "numbers", "simple_quote", "double_quote"
# "9", "quoted text", "{""Q0"":""double double quote""}"
library(readr)
library(data.table)
read.csv("test.csv")
#> numbers simple_quote double_quote
#> 1 9 quoted text {"Q0":"double double quote"}
read_csv("test.csv")
#> # A tibble: 1 x 3
#> numbers simple_quote double_quote
#> <dbl> <chr> <chr>
#> 1 9 quoted text "{\"Q0\":\"double double quote\"}"
fread("test.csv")
#> numbers simple_quote double_quote
#> 1: 9 quoted text {""Q0"":""double double quote""}
Created on 2021-04-09 by the reprex package (v2.0.0)