Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why the field separator character must be only one byte?

Tags:

text

r

delimiter

data <- read.delim("C:\\test.txt", header = FALSE, sep = "$$$$$")
Error in scan(file, what = "", sep = sep, quote = quote, nlines = 1, quiet = TRUE,  : 
  invalid 'sep' value: must be one byte

Why there is a restriction like this? Can I overcome it?

like image 431
George Dontas Avatar asked Apr 28 '10 19:04

George Dontas


1 Answers

Here is a potential solution.

Assuming this is what the lines in your file look like

1$$$$$2$$$$$3$$$$$4

The following will create a matrix with the variables stored as characters.

do.call(rbind,strsplit(readLines('test.txt'),'$$$$$',fixed=T))
like image 72
wkmor1 Avatar answered Nov 15 '22 09:11

wkmor1