quick solution to many parser problems?

[Robert J]

I was having trouble with the parser. It NEVER worked for me and I didn’t feel like taking the time to learn why.

QRT engine gives you something that looks like the following in a single cell for every participant for every trial:

{ InitPre[OnsetTime] : 1434422270568.945 , InitPre[OffsetTime] : 1434422272049.99 , InitPre[CalculatedDuration] : 1481.044921875 , Init[OnsetTime] : 1434422272050.175 , SimpleRTBLock[InterTrialDelay] : 800 , BlankInterval[Duration] : 400 , StroopItem[Allowable] : rgyb , StroopItem[CRESP] : r , StroopItem[EndAction] : TERMINATE , CorFeedback[Duration] : 400 , IncFeedback[Duration] : 400 , Congruency : con , InitPost[Duration] : 0 , Init[OffsetTime] : 1434422272081.715 , Init[CalculatedDuration] : 31.5400390625 , InitPost[OnsetTime] : 1434422272081.715 , InitPost[OffsetTime] : 1434422272120.271 , InitPost[CalculatedDuration] : 38.555908203125 , BlankInterval[OnsetTime] : 1434422272121.656 , BlankInterval[OffsetTime] : 1434422272533.161 , BlankInterval[CalculatedDuration] : 411.5048828125 , StroopItem[RTTime] : 1434422273169.781 , StroopItem[RT] : 635.179931640625 , StroopItem[RESP] : r , StroopItem[ACC] : 1 , StroopItem[OnsetTime] : 1434422272534.601 , SimpleRTBLockStroopItem[Resp] : \u0000 , StroopItem[OffsetTime] : 1434422273182.566 , StroopItem[CalculatedDuration] : 647.96484375 , CorFeedback[OnsetTime] : 1434422273183.536 , CorFeedback[OffsetTime] : 1434422273582.109 , CorFeedback[CalculatedDuration] : 398.572998046875 , undefined[OnsetTime] : 1434422273582.726 , SimpleRTBLock[TrialNr] : 92 , SimpleRTBLock[RefreshPeriod] : 16.72607421875 , BlockId : SimpleRTBLock , EngineType : native-highres , Exit[OnsetTime] : 1434422273583.144 }

… I did have to substitute quotation marks in the QRT output with blank spaces … that’s the first step. If you look at your own data you’ll see what I mean. After replacing the quotation marks with blank spaces (which is already done in the text above), I was able to extract all of the response-time data with the following formula in Excel:

=IF(ISBLANK(A4)=FALSE, MID(A4, FIND(“[RT] : “, A4)+7, FIND(“, StroopItem[RESP]”, A4)-FIND(“[RT] : “, A4)-7), “”)

Hoping somebody else might find this useful.

[Author]

Posts