Adding a character before every specific character in each line in R

Question

I have a .csv, file unfortunately one of the columns contains a dictionary that has commas in it , for example:

{"name": "Umbulharjo", "type": "Kecamatan", "level": "3", "region1": "Yogyakarta", "region2": "Yogyakarta", "region3": "Umbulharjo", "postcode": "55161"}

How can i put a " before every { and after every } in R? then i can set " as quote when i am using read.csv or read.csv2 or read.table

`rl <- readLines('test.csv'); rl <- gsub('(?={)|(?<=})', '\'', rl, perl = TRUE); read.csv(text = rl, quote = '\'')` maybe — rawr, Apr 25 '16 at 06:42
Sorry i missed the paste http://stackoverflow.com/questions/11936339/in-r-how-do-i-replace-text-within-a-string — RanchiRhino, Apr 25 '16 at 06:47
https://susanejohnston.wordpress.com/2012/10/01/find-and-replace-in-r-part-2-how-to-recode-many-values-simultaneously/ — RanchiRhino, Apr 25 '16 at 06:48

score 1 · Answer 1 · edited May 23 '17 at 12:17

1

Your data looks to be JSON-ish. If you're doing a lot of JSON stuff, I suggest using a library that understands JSON.

edited May 23 '17 at 12:17

Community

1
1

answered Apr 25 '16 at 06:44

Bob Salmon

411
4
10

NO it is not JSON at all only one columns has this structure out of 45 . – Hossein Yousefi Apr 25 '16 at 06:49

score 0 · Answer 2 · answered Apr 25 '16 at 06:40

0

paste('{"name": "Umbulharjo", "type": "Kecamatan", "level": "3", "region1": "Yogyakarta", "region2": "Yogyakarta", "region3": "Umbulharjo", "postcode": "55161"}', '')
#[1] "{\"name\": \"Umbulharjo\", \"type\": \"Kecamatan\", \"level\": \"3\", \"region1\": \"Yogyakarta\", \"region2\": \"Yogyakarta\", \"region3\": \"Umbulharjo\", \"postcode\": \"55161\"} "

answered Apr 25 '16 at 06:40

Sotos

51,121
6
32
66

2.5 million rows how can i paste? – Hossein Yousefi Apr 25 '16 at 06:43
`paste` is vectorised. – Sotos Apr 25 '16 at 06:45

Adding a character before every specific character in each line in R

2 Answers2