strsplit in R with a metacharacter

6.5k views Asked by At

I have a large amount of data where the delimiter is a backslash. I'm processing it in R and I'm having a hard time finding how to split the string since the backslash is a metacharacter. For example, a string would look like this:

1128\0019\XA5\E2R\366\00=15

and I want to split it along the \ character, but when I run the strsplit command:

strsplit(tempStr, "\\")
Error in strsplit(tempStr, "\\") : 
  invalid regular expression '\', reason 'Trailing backslash'

When I try to used the "fixed" option, it does not run because it is expecting something after the backslash:

strsplit(tempStr, "\", fixed = TRUE)

Unfortunately, I can't preprocess the data with another program because the data is generated daily.

3

There are 3 answers

4
David Robinson On

Your line of code is (though you don't say it explicitly):

strsplit(tempStr, "\\")

and should be

strsplit(tempStr, "\\\\")

This will be read as "\\", which the regular expression will understand as a "\".

0
csgillespie On

I suspect that your data is in a file of some sort. If this is the case, then use read.table but specify the delimiter explicitly. For example, suppose your file was:

a\b\c\d
e\f\g\h

then to read this into R, use the command:

read.table("file.txt", sep="\\")
0
Li Chen On

Try this:

strsplit(tempStr, "\"")