Maybe you can use ',=' as separators. ( I don't have R to check).
Otherwise, I would clean the file with an editor or tool like 'sed' to
replace the regular expression /key[0-9]=/ by nothing.
On Jan 18, 2013 8:05 AM, "Frank Singleton" <b17flyboy@gmail.com> wrote:

> Hi,
>
> Thanks for a great environmentfor statistical  computing :-)
>
> I have some input data in a file ("input_kvpairs.csv") of the form
>
> key1=23, key2=67, key3="hello there"
> key1=7, key2=22, key3="how are you"
> key1=2, key2=77, key3="nice day, thanks"
>
> Now in my head I wish it was of the form ("input.csv")
>
> #key1, key2, key3
> 23,    67,   "hello there"
> 7,     22,   "how are you"
> 2,     77,   "nice day, thanks"
>
> so I could do
>
> data <- read.csv("input.csv", header=TRUE)
>
> where the header column names are derived from the key names dynamically,
> and I could access the data using normal data$key1 or data$key2 mechanism.
>
> I guess I could just pre process the file first  using python etc to create
> a CSV file with column header derived from key names, and values derived
> from
> key values, but I am interested to see how experienced R folks would
> handle this
> inside R.
>
> Thanks,
>
> Frank
>
> ______________________________**________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help>
> PLEASE do read the posting guide http://www.R-project.org/**
> posting-guide.html <http://www.R-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>

	[[alternative HTML version deleted]]

