parsing text in R

Asked Jun 27 '14 at 20:28

Active Nov 15 '14 at 14:02

Viewed 69 times

I have to parse a third party supplied text that is in following format:

"{ \"responseObjects\" : [ { \"isCorrect\" : \"F\" , \"displayText\" : \"8,11\" , \"displayOrder\" : 1} , { \"isCorrect\" : \"F\" , \"displayText\" : \"9,13\" , \"displayOrder\" : 2} , { \"isCorrect\" : \"T\" , \"displayText\" : \"'11, 13\" , \"displayOrder\" : 3} , { \"isCorrect\" : \"F\" , \"displayText\" : \"'12,15\" , \"displayOrder\" : 4}] , \"stem\" : { \"displayText\" : \"Extend the numerical pattern: 1, 2, 3, 5, 7, ____, ____\"}}"

the \ are escape characters. The entire text above is a cell in a dataframe (read from a database)

I need to grab the text that comes after "stem", i.e., every entry will have the key word "stem" : { "display test" : "actual text"} } any suggestions on how I can grab the "actual text" in the sentence. (all other text are not relevant to the app) Thank you very much.

edited Nov 15 '14 at 14:02

Thomas

43,637
12
109
140

asked Jun 27 '14 at 20:28

user3763914

same text as above, without the \ escape character – user3763914 Jun 27 '14 at 20:31
2

possible duplicate of [Parse JSON with R](http://stackoverflow.com/questions/2061897/parse-json-with-r) – Soren Jun 27 '14 at 20:37
Parse the string using a JSON parser, and then extract the fields from the resulting object. – Soren Jun 27 '14 at 20:39
Thanks got it! JSON parser works. – user3763914 Jun 27 '14 at 20:54

parsing text in R

0 Answers0