How can I parse the next scorm data, output from Articulate StoryLine 2

0, Module xx','cmi.interactions.0.id','Scene4_Slide3_SequenceDragDrop_0_0'
0, Module xx','cmi.interactions.0.latency','0000:00:28.16'
0, Module xx','cmi.interactions.0.result','correct'
0, Module xx','cmi.interactions.0.time','09:08:05'
0, Module xx','cmi.interactions.0.type','sequencing'
1, Module xx','cmi.interactions.1.id','Scene4_Slide4_MultiChoice_0_0'
1, Module xx','cmi.interactions.1.latency','0000:00:06.35'
1, Module xx','cmi.interactions.1.result','correct'
1, Module xx','cmi.interactions.1.time','09:08:12'
1, Module xx','cmi.interactions.1.type','choice'

I would like have the result
0, id, latency, result, time, type
1, id, latency, result, time, type

So the values would be:
0, 'Scene4_Slide3_SequenceDragDrop_0_0', '0000:00:28.16', 'correct', '09:08:05', 'sequencing'
1, 'Scene4_Slide4_MultiChoice_0_0', '0000:00:06.35', 'correct', '09:08:12', 'choice'

I am using SQL-Server to parse the data.

Thanks in advance for your help

1 Reply