[R] strsplit on comma, with a trailing comma in input
Peter Dalgaard
p.dalgaard at biostat.ku.dk
Tue Dec 4 00:44:28 CET 2007
dankelley wrote:
> I have a comma-separated data file in which trailing commas sometimes occur.
> I am using strsplit to extract the data from this file, and it seems great
> except in cases with trailing comma characters.
>
> The example below illustrates. What I'd like is to get a fourth element in
> the answer, being an empty string just like the second element. Is there a
> way I can express my patter (or perhaps specify perl or extended) to get
> that?
>
>
>
>> strsplit("a,,b,", ",")[[1]]
>>
> [1] "a" "" "b"
>
Hmm, I don't think strsplit can do that. However:
> scan(textConnection("a,,b,"), sep=",", what="")
Read 4 items
[1] "a" "" "b" ""
--
O__ ---- Peter Dalgaard Øster Farimagsgade 5, Entr.B
c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K
(*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907
More information about the R-help
mailing list