fedyakov fedyakov - 1 year ago 69
R Question

How to read CSV with \", sequence inside quoted character value in R?

Here is a CSV file with two character columns:


All character values are quoted by double quotes. And there is a sequence
inside one of the values (escaped quote plus delimiter). I cannot correctly read this file neither by read.csv, nor by read_csv from readr, nor by fread from data.table.

Answer Source

You can use readr's read_delim, which is more general than read_csv:


           delim = ",", 
           escape_double = FALSE, 
           escape_backslash = TRUE)