"," separator in read.csv - R

Question

How to define "," as the column separator (sep) in read.csv in R? I have tried read.csv(file=x,header = FALSE,sep = "",""), which doest work correctly.

The default separator in `read.csv` is already comma. So, just omit the `sep=","` part and it should work. — Tim Biegeleisen, May 28 '19 at 16:31
@TimBiegeleisen, I have the double quotation as well that I want to use as the seperator. — Ester Silva, May 28 '19 at 16:32
You may have to parse the file manually then, [see here](https://stackoverflow.com/questions/18186357/importing-csv-file-with-multiple-character-separator-to-r). — Tim Biegeleisen, May 28 '19 at 16:34
You probably want to set both the quotes and sep option then. Do the individual lines begin/end with `"`s? — Neal Fultz, May 28 '19 at 17:31

score 0 · Answer 1 · answered May 28 '19 at 16:52

0

sep can only be one character, but you can open your file x e.g. with readLines and exchange your "," separator e.g. with \t by using gsub.

read.table(text=gsub("\",\"", "\t", readLines("x")))

answered May 28 '19 at 16:52

GKi

37,245
2
26
48

"," separator in read.csv - R

1 Answers1