Ivan Krylov
2025-Sep-14 19:13 UTC
[R] trouble with exporting a data.frame with " (quotation mark) in some columns into a tab delimited file, then importing the file
? Sun, 14 Sep 2025 19:39:58 +0200 Patrick Giraudoux <patrick.giraudoux at univ-fcomte.fr> ?????:> write.table(db, file = "db.txt", row.names = FALSE, quote = FALSE, > sep = "\t") > > db_import<-read.delim("db.txt")Since write.table() had been called with quote=FALSE, you'll need to read the file with quote="" to prevent read.delim() from interpreting the quotes. -- Best regards, Ivan
Patrick Giraudoux
2025-Sep-14 19:31 UTC
[R] trouble with exporting a data.frame with " (quotation mark) in some columns into a tab delimited file, then importing the file
with quote="" I get an error, Yvan> write.table(db, file = "db.txt", row.names = FALSE, quote="", sep = "\t")Show Traceback Rerun with Debug Errorin write.table(db, file = "db.txt", row.names = FALSE, quote = "", : invalid 'quote' specification Le 14/09/2025 ? 21:13, Ivan Krylov a ?crit?:> ? Sun, 14 Sep 2025 19:39:58 +0200 > Patrick Giraudoux<patrick.giraudoux at univ-fcomte.fr> ?????: > >> write.table(db, file = "db.txt", row.names = FALSE, quote = FALSE, >> sep = "\t") >> >> db_import<-read.delim("db.txt") > Since write.table() had been called with quote=FALSE, you'll need to > read the file with quote="" to prevent read.delim() from interpreting > the quotes. >