﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Millisecond Forums » Millisecond Forums » Inquisit 5  » data in wide format</title><generator>InstantForum 2017-1 Final</generator><description>Millisecond Forums</description><link>https://forums.millisecond.com/</link><webMaster>Millisecond Forums</webMaster><lastBuildDate>Thu, 24 Sep 2026 12:36:54 GMT</lastBuildDate><ttl>20</ttl><item><title>data in wide format</title><link>https://forums.millisecond.com/Topic28416.aspx</link><description>Hey Dave,&lt;br/&gt;&lt;br/&gt;you kindly did help me with the following script and I have one more question concerning the data file: Now, the data are saved in long format (see file attached). However, I would like them to be saved like that:&lt;br/&gt;Collumns: subject, date, time, A_negpos, A1_negpos ... A_symp, A1_symp ..., values.sequence&lt;br/&gt;&lt;br/&gt;How can I do that?&lt;br/&gt;&lt;br/&gt;This is the script:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; values.item = list.items.nextvalue;&lt;br/&gt;&amp;nbsp; values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;&amp;nbsp; list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = false;&lt;br/&gt;&amp;nbsp; } else {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = true;&lt;br/&gt;&amp;nbsp; };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;&amp;nbsp; values.item = "";&lt;br/&gt;&amp;nbsp; values.sequence = "";&lt;br/&gt;&amp;nbsp; list.items.reset():&lt;br/&gt;&amp;nbsp; list.pages.reset();&lt;br/&gt;&amp;nbsp; list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;&amp;nbsp; if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false &lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;***************************************************** &lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black &lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Thank you a lot!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;</description><pubDate>Tue, 10 Mar 2020 11:56:54 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28481.aspx</link><description>&lt;blockquote data-id="28480" class="if-quote-wrapper" unselectable="on" data-guid="1583841283177" id="if_insertedNode_1583841281873" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28480" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28480" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28480" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/10/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28480"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28473" class="if-quote-wrapper" unselectable="on" data-guid="1583841283177" id="if_insertedNode_1583828453345" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28473" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28473" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28473" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;Dave - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28473"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28472" class="if-quote-wrapper" unselectable="on" data-guid="1583841283177" id="if_insertedNode_1583762778793" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28472" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28472" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28472" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28472"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;sorry, OK:&lt;br/&gt;Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;Meaning: First, Inquisit should sort according to prime. Then according to target and then sort columns like that (the number indicates the trial):&lt;br/&gt;&lt;br/&gt;subject&amp;nbsp;&amp;nbsp; time &amp;nbsp; date&amp;nbsp;&amp;nbsp; values.prime1&amp;nbsp;&amp;nbsp; values.target1 &amp;nbsp; values.targetcategory1&amp;nbsp;&amp;nbsp; response1&amp;nbsp;&amp;nbsp; correct1&amp;nbsp;&amp;nbsp; latency1&amp;nbsp;&amp;nbsp; values.prime2 values.target2 values.targetcategory2 response2 correct2 latency2&amp;nbsp;&amp;nbsp; values.prime3 values.target3 values.targetcategory3 response3 correct3 latency3 ......values.prime200 values.target200 values.targetcategory200 response200 correct200 latency200  &lt;br/&gt;&lt;br/&gt;Thank you very much!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28472"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;&amp;gt; Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;&lt;br/&gt;No, not really. The only thing you can do is create values, populate them as needed and have the summary data file write them out as discussed previously. Obviously, given the amount of stimuli involved here, that would be extremely tedious, and you're better off transposing the raw data file using your preferred data analysis application.&lt;br/&gt;&lt;br/&gt;I'm also struggling to see for what kind of analysis that would be a desirable or suitable data format, to be perfectly honest.&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28473"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;thanks for your answer! We did transpose everything ourselves in previous studies (with the AMP for example) and I found it quite laborious.&lt;br/&gt; &lt;br/&gt;As for your last remark: I understand that it seems a bit weird to want such a format. In the end, we simply need the facilitation scores for each of the 10 stimuli after dealing with too long latencies and filtering for erroneous trials. Therefore, we need this incredibly long raw file (we are working with SPSS). I hope that was understanble.&lt;br/&gt;&lt;br/&gt;Thank you again for your help and thoughts!&lt;br/&gt;R.&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28480"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;Perhaps it would be easier to have Inquisit calculate the facilitation scores directly, but to say whether that's possible, you'd have to describe in detail how you want to compute those.&lt;br/&gt;</description><pubDate>Tue, 10 Mar 2020 11:56:54 GMT</pubDate><dc:creator>Dave</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28480.aspx</link><description>&lt;blockquote data-id="28473" class="if-quote-wrapper" unselectable="on" data-guid="1583828454714" id="if_insertedNode_1583828453345" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28473" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28473" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28473" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;Dave - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28473"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28472" class="if-quote-wrapper" unselectable="on" data-guid="1583828454714" id="if_insertedNode_1583762778793" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28472" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28472" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28472" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28472"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;sorry, OK:&lt;br/&gt;Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;Meaning: First, Inquisit should sort according to prime. Then according to target and then sort columns like that (the number indicates the trial):&lt;br/&gt;&lt;br/&gt;subject&amp;nbsp;&amp;nbsp; time &amp;nbsp; date&amp;nbsp;&amp;nbsp; values.prime1&amp;nbsp;&amp;nbsp; values.target1 &amp;nbsp; values.targetcategory1&amp;nbsp;&amp;nbsp; response1&amp;nbsp;&amp;nbsp; correct1&amp;nbsp;&amp;nbsp; latency1&amp;nbsp;&amp;nbsp; values.prime2 values.target2 values.targetcategory2 response2 correct2 latency2&amp;nbsp;&amp;nbsp; values.prime3 values.target3 values.targetcategory3 response3 correct3 latency3 ......values.prime200 values.target200 values.targetcategory200 response200 correct200 latency200  &lt;br/&gt;&lt;br/&gt;Thank you very much!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28472"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;&amp;gt; Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;&lt;br/&gt;No, not really. The only thing you can do is create values, populate them as needed and have the summary data file write them out as discussed previously. Obviously, given the amount of stimuli involved here, that would be extremely tedious, and you're better off transposing the raw data file using your preferred data analysis application.&lt;br/&gt;&lt;br/&gt;I'm also struggling to see for what kind of analysis that would be a desirable or suitable data format, to be perfectly honest.&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28473"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;thanks for your answer! We did transpose everything ourselves in previous studies (with the AMP for example) and I found it quite laborious.&lt;br/&gt; &lt;br/&gt;As for your last remark: I understand that it seems a bit weird to want such a format. In the end, we simply need the facilitation scores for each of the 10 stimuli after dealing with too long latencies and filtering for erroneous trials. Therefore, we need this incredibly long raw file (we are working with SPSS). I hope that was understanble.&lt;br/&gt;&lt;br/&gt;Thank you again for your help and thoughts!&lt;br/&gt;R.&lt;br/&gt;</description><pubDate>Tue, 10 Mar 2020 08:29:51 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28473.aspx</link><description>&lt;blockquote data-id="28472" class="if-quote-wrapper" unselectable="on" data-guid="1583762779614" id="if_insertedNode_1583762778793" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28472" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28472" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28472" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28472"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;sorry, OK:&lt;br/&gt;Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;Meaning: First, Inquisit should sort according to prime. Then according to target and then sort columns like that (the number indicates the trial):&lt;br/&gt;&lt;br/&gt;subject&amp;nbsp;&amp;nbsp; time &amp;nbsp; date&amp;nbsp;&amp;nbsp; values.prime1&amp;nbsp;&amp;nbsp; values.target1 &amp;nbsp; values.targetcategory1&amp;nbsp;&amp;nbsp; response1&amp;nbsp;&amp;nbsp; correct1&amp;nbsp;&amp;nbsp; latency1&amp;nbsp;&amp;nbsp; values.prime2 values.target2 values.targetcategory2 response2 correct2 latency2&amp;nbsp;&amp;nbsp; values.prime3 values.target3 values.targetcategory3 response3 correct3 latency3 ......values.prime200 values.target200 values.targetcategory200 response200 correct200 latency200  &lt;br/&gt;&lt;br/&gt;Thank you very much!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28472"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;&amp;gt; Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;&lt;br/&gt;No, not really. The only thing you can do is create values, populate them as needed and have the summary data file write them out as discussed previously. Obviously, given the amount of stimuli involved here, that would be extremely tedious, and you're better off transposing the raw data file using your preferred data analysis application.&lt;br/&gt;&lt;br/&gt;I'm also struggling to see for what kind of analysis that would be a desirable or suitable data format, to be perfectly honest.&lt;br/&gt;</description><pubDate>Mon, 09 Mar 2020 14:11:41 GMT</pubDate><dc:creator>Dave</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28472.aspx</link><description>Hi Dave,&lt;br/&gt;&lt;br/&gt;sorry, OK:&lt;br/&gt;Is it possible that Inquisit saves the data in a wide format with which we would not have to transpone anymore?&lt;br/&gt;Meaning: First, Inquisit should sort according to prime. Then according to target and then sort columns like that (the number indicates the trial):&lt;br/&gt;&lt;br/&gt;subject&amp;nbsp;&amp;nbsp; time &amp;nbsp; date&amp;nbsp;&amp;nbsp; values.prime1&amp;nbsp;&amp;nbsp; values.target1 &amp;nbsp; values.targetcategory1&amp;nbsp;&amp;nbsp; response1&amp;nbsp;&amp;nbsp; correct1&amp;nbsp;&amp;nbsp; latency1&amp;nbsp;&amp;nbsp; values.prime2 values.target2 values.targetcategory2 response2 correct2 latency2&amp;nbsp;&amp;nbsp; values.prime3 values.target3 values.targetcategory3 response3 correct3 latency3 ......values.prime200 values.target200 values.targetcategory200 response200 correct200 latency200  &lt;br/&gt;&lt;br/&gt;Thank you very much!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;</description><pubDate>Mon, 09 Mar 2020 14:04:10 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28460.aspx</link><description>&lt;blockquote data-id="28456" class="if-quote-wrapper" unselectable="on" data-guid="1583755964567" id="if_insertedNode_1583755963642" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28456" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28456" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28456" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28456"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28455" class="if-quote-wrapper" unselectable="on" data-guid="1583755964567" id="if_insertedNode_1583745651202" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28455" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28455" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28455" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28455"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;I have a similar proplem with my evaluative priming task. I am posting this here because I think it fits. &lt;br/&gt;I have the same stimuli as above (A, A1 - A4 and B, B1-B4). For now, in the summary data file only summarized values for Apos, Aneg, Bpos, and Bneg are saved. I wanted to implement what you posted above (in each trial for example: / ontrialend = [values.A4_neg = A4neg; latency]).&lt;br/&gt;However, there are no single trial descriptions for each stimulus, because items are pulled from a list. &lt;br/&gt;How can I create a summary file that gives latency and correct values for each stimulus in positive and negative conditions? (file is attached)&lt;br/&gt;&lt;br/&gt;Thank you very much in advance!&lt;br/&gt;R.&lt;br/&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28456"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;I don't understand what you want the summary file to look like.&lt;br/&gt;</description><pubDate>Mon, 09 Mar 2020 12:15:08 GMT</pubDate><dc:creator>Dave</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28456.aspx</link><description>&lt;blockquote data-id="28455" class="if-quote-wrapper" unselectable="on" data-guid="1583745652853" id="if_insertedNode_1583745651202" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28455" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28455" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28455" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/9/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28455"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;I have a similar proplem with my evaluative priming task. I am posting this here because I think it fits. &lt;br/&gt;I have the same stimuli as above (A, A1 - A4 and B, B1-B4). For now, in the summary data file only summarized values for Apos, Aneg, Bpos, and Bneg are saved. I wanted to implement what you posted above (in each trial for example: / ontrialend = [values.A4_neg = A4neg; latency]).&lt;br/&gt;However, there are no single trial descriptions for each stimulus, because items are pulled from a list. &lt;br/&gt;How can I create a summary file that gives latency and correct values for each stimulus in positive and negative conditions? (file is attached)&lt;br/&gt;&lt;br/&gt;Thank you very much in advance!&lt;br/&gt;R.&lt;br/&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;</description><pubDate>Mon, 09 Mar 2020 09:32:00 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28455.aspx</link><description>Hey Dave,&lt;br/&gt;I have a similar proplem with my evaluative priming task. I am posting this here because I think it fits. &lt;br/&gt;I have the same stimuli as above (A, A1 - A4 and B, B1-B4). For now, in the summary data file only summarized values for Apos, Aneg, Bpos, and Bneg are saved. I wanted to implement what you posted above (in each trial for example: &lt;br/&gt;/ ontrialend = [values.A4_neg = slider.negpos.response;&lt;br/&gt;&amp;nbsp; values.A4_symp = slider.symp.response;&lt;br/&gt;])&lt;br/&gt;</description><pubDate>Mon, 09 Mar 2020 09:20:44 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28433.aspx</link><description>&lt;blockquote data-id="28424" class="if-quote-wrapper" unselectable="on"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28424" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28424" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28424" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/5/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28424"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Ay...should have known...thank you a lot! I will try it out today!&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28424"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;&lt;br/&gt;It worked! Thank you, Dave! &lt;br/&gt;&lt;br/&gt;</description><pubDate>Thu, 05 Mar 2020 14:06:14 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28426.aspx</link><description>&lt;blockquote data-id="28425" class="if-quote-wrapper" unselectable="on" data-guid="1583413902156" id="if_insertedNode_1583413900725" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28425" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28425" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28425" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;&lt;a href="mailto:w.cao@uu.nl"&gt;w.cao@uu.nl&lt;/a&gt; - 3/5/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28425"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28417" class="if-quote-wrapper" unselectable="on" data-guid="1583413902156" id="if_insertedNode_1583412872701" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28417" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28417" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28417" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;Dave - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28417"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28416" class="if-quote-wrapper" unselectable="on" data-guid="1583413902156" id="if_insertedNode_1583337449040" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28416" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28416" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28416" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28416"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;you kindly did help me with the following script and I have one more question concerning the data file: Now, the data are saved in long format (see file attached). However, I would like them to be saved like that:&lt;br/&gt;Collumns: subject, date, time, A_negpos, A1_negpos ... A_symp, A1_symp ..., values.sequence&lt;br/&gt;&lt;br/&gt;How can I do that?&lt;br/&gt;&lt;br/&gt;This is the script:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; values.item = list.items.nextvalue;&lt;br/&gt;&amp;nbsp; values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;&amp;nbsp; list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = false;&lt;br/&gt;&amp;nbsp; } else {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = true;&lt;br/&gt;&amp;nbsp; };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;&amp;nbsp; values.item = "";&lt;br/&gt;&amp;nbsp; values.sequence = "";&lt;br/&gt;&amp;nbsp; list.items.reset():&lt;br/&gt;&amp;nbsp; list.pages.reset();&lt;br/&gt;&amp;nbsp; list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;&amp;nbsp; if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false &lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;***************************************************** &lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black &lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Thank you a lot!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28416"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;You can create variables (i.e. &amp;lt;values&amp;gt;) capturing the data of interest and then write out a single-line (wide format) file via &amp;lt;summarydata&amp;gt;.&lt;a class="if-quote-goto quote-link" href="#" data-id="28417"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;I am really sorry that I checked the language reference website but still unclear about how to use &amp;lt;values&amp;gt;.&amp;nbsp;&lt;br/&gt;Examples were given like tracking the total score and sum of squares of response latencies.&lt;br/&gt;What I want to track is the text answer.&lt;br/&gt;&lt;br/&gt;&amp;lt;textbox friend_firstname&amp;gt;&lt;br/&gt;/ caption = "Please write down the first name of this person. "&lt;br/&gt;/ mask = alphabetic&lt;br/&gt;/ minchars = 50&amp;nbsp; &amp;nbsp;***without mask but add a limitation&lt;br/&gt;&amp;lt;/textbox&amp;gt;&lt;br/&gt;&lt;br/&gt;How could I track the answer that participant give?&lt;br/&gt;e.g., participant A answered Anna, participants B answered Luna, participant C ...&lt;br/&gt;And next question is&amp;nbsp;&lt;br/&gt;&lt;br/&gt;&amp;lt;radiobuttons satisfaction&amp;gt;&lt;br/&gt;/ caption = "I usually know how satisfied '&lt;strong&gt;&amp;lt;%textbox.friend_firstname%&amp;gt;&lt;/strong&gt;' is with what I do"&lt;br/&gt;/ options = ("1  (strongly disagree)", "&amp;nbsp;&amp;nbsp;2&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;3&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;4&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;5&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;6&amp;nbsp;&amp;nbsp;", "  7 (strongly agree)")&lt;br/&gt;/ optionvalues = ("1", "2", "3", "4", "5", "6", "7")&lt;br/&gt;/ orientation = horizontal&lt;br/&gt;&amp;lt;/radiobuttons&amp;gt;&lt;br/&gt;&lt;br/&gt;Thank you very much!&lt;br/&gt;Wenrui&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28425"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;Please ask your questions in the thread they belong to &lt;a href="https://www.millisecond.com/forums/Topic28412.aspx."&gt;&lt;a href="https://www.millisecond.com/forums/Topic28412.aspx"&gt;https://www.millisecond.com/forums/Topic28412.aspx&lt;/a&gt;&lt;/a&gt; &lt;br/&gt;&lt;br/&gt;Thank you.</description><pubDate>Thu, 05 Mar 2020 13:15:15 GMT</pubDate><dc:creator>Dave</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28425.aspx</link><description>&lt;blockquote data-id="28417" class="if-quote-wrapper" unselectable="on" data-guid="1583412873410" contenteditable="false" id="if_insertedNode_1583412872701"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28417" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28417" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28417" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;Dave - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28417"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28416" class="if-quote-wrapper" unselectable="on" data-guid="1583412873410" id="if_insertedNode_1583337449040" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28416" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28416" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28416" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28416"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;you kindly did help me with the following script and I have one more question concerning the data file: Now, the data are saved in long format (see file attached). However, I would like them to be saved like that:&lt;br/&gt;Collumns: subject, date, time, A_negpos, A1_negpos ... A_symp, A1_symp ..., values.sequence&lt;br/&gt;&lt;br/&gt;How can I do that?&lt;br/&gt;&lt;br/&gt;This is the script:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; values.item = list.items.nextvalue;&lt;br/&gt;&amp;nbsp; values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;&amp;nbsp; list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = false;&lt;br/&gt;&amp;nbsp; } else {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = true;&lt;br/&gt;&amp;nbsp; };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;&amp;nbsp; values.item = "";&lt;br/&gt;&amp;nbsp; values.sequence = "";&lt;br/&gt;&amp;nbsp; list.items.reset():&lt;br/&gt;&amp;nbsp; list.pages.reset();&lt;br/&gt;&amp;nbsp; list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;&amp;nbsp; if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false &lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;***************************************************** &lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black &lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Thank you a lot!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28416"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;You can create variables (i.e. &amp;lt;values&amp;gt;) capturing the data of interest and then write out a single-line (wide format) file via &amp;lt;summarydata&amp;gt;.&lt;a class="if-quote-goto quote-link" href="#" data-id="28417"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;Hi Dave,&lt;br/&gt;&lt;br/&gt;I am really sorry that I checked the language reference website but still unclear about how to use &amp;lt;values&amp;gt;.&amp;nbsp;&lt;br/&gt;Examples were given like tracking the total score and sum of squares of response latencies.&lt;br/&gt;What I want to track is the text answer.&lt;br/&gt;&lt;br/&gt;&amp;lt;textbox friend_firstname&amp;gt;&lt;br/&gt;/ caption = "Please write down the first name of this person. "&lt;br/&gt;/ mask = alphabetic&lt;br/&gt;/ minchars = 50&amp;nbsp; &amp;nbsp;***without mask but add a limitation&lt;br/&gt;&amp;lt;/textbox&amp;gt;&lt;br/&gt;&lt;br/&gt;How could I track the answer that participant give?&lt;br/&gt;e.g., participant A answered Anna, participants B answered Luna, participant C ...&lt;br/&gt;And next question is&amp;nbsp;&lt;br/&gt;&lt;br/&gt;&amp;lt;radiobuttons satisfaction&amp;gt;&lt;br/&gt;/ caption = "I usually know how satisfied '&lt;strong&gt;&amp;lt;%textbox.friend_firstname%&amp;gt;&lt;/strong&gt;' is with what I do"&lt;br/&gt;/ options = ("1  (strongly disagree)", "&amp;nbsp;&amp;nbsp;2&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;3&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;4&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;5&amp;nbsp;&amp;nbsp;", "&amp;nbsp;&amp;nbsp;6&amp;nbsp;&amp;nbsp;", "  7 (strongly agree)")&lt;br/&gt;/ optionvalues = ("1", "2", "3", "4", "5", "6", "7")&lt;br/&gt;/ orientation = horizontal&lt;br/&gt;&amp;lt;/radiobuttons&amp;gt;&lt;br/&gt;&lt;br/&gt;Thank you very much!&lt;br/&gt;Wenrui&lt;br/&gt;</description><pubDate>Thu, 05 Mar 2020 13:02:20 GMT</pubDate><dc:creator>w.cao@uu.nl</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28424.aspx</link><description>Ay...should have known...thank you a lot! I will try it out today!&lt;br/&gt;</description><pubDate>Thu, 05 Mar 2020 12:50:54 GMT</pubDate><dc:creator>mongrel</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28419.aspx</link><description>&lt;blockquote data-id="28418" class="if-quote-wrapper" unselectable="on" data-guid="1583338458343" id="if_insertedNode_1583338458079" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28418" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28418" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28418" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;&lt;a href="mailto:w.cao@uu.nl"&gt;w.cao@uu.nl&lt;/a&gt; - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28418"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28417" class="if-quote-wrapper" unselectable="on" data-guid="1583338458343" id="if_insertedNode_1583337627554" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28417" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28417" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28417" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;Dave - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28417"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28416" class="if-quote-wrapper" unselectable="on" data-guid="1583338458343" id="if_insertedNode_1583337449040" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28416" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28416" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28416" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28416"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;you kindly did help me with the following script and I have one more question concerning the data file: Now, the data are saved in long format (see file attached). However, I would like them to be saved like that:&lt;br/&gt;Collumns: subject, date, time, A_negpos, A1_negpos ... A_symp, A1_symp ..., values.sequence&lt;br/&gt;&lt;br/&gt;How can I do that?&lt;br/&gt;&lt;br/&gt;This is the script:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; values.item = list.items.nextvalue;&lt;br/&gt;&amp;nbsp; values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;&amp;nbsp; list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = false;&lt;br/&gt;&amp;nbsp; } else {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = true;&lt;br/&gt;&amp;nbsp; };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;&amp;nbsp; values.item = "";&lt;br/&gt;&amp;nbsp; values.sequence = "";&lt;br/&gt;&amp;nbsp; list.items.reset():&lt;br/&gt;&amp;nbsp; list.pages.reset();&lt;br/&gt;&amp;nbsp; list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;&amp;nbsp; if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false &lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;***************************************************** &lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black &lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Thank you a lot!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28416"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;You can create variables (i.e. &amp;lt;values&amp;gt;) capturing the data of interest and then write out a single-line (wide format) file via &amp;lt;summarydata&amp;gt;.&lt;a class="if-quote-goto quote-link" href="#" data-id="28417"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;I will have a try, thank you very much!&lt;a class="if-quote-goto quote-link" href="#" data-id="28418"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;In essence:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;  values.item = list.items.nextvalue;&lt;br/&gt;  values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;  list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;  if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;values.valid_sequence = false;&lt;br/&gt;  } else {&lt;br/&gt;&amp;nbsp;values.valid_sequence = true;&lt;br/&gt;  };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;  values.item = "";&lt;br/&gt;  values.sequence = "";&lt;br/&gt;  list.items.reset():&lt;br/&gt;  list.pages.reset();&lt;br/&gt;  list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;  if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A1_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A1_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A2_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A2_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A3_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A3_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A4_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A4_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B1_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B1_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B2_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B2_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B3_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B3_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B4_negpos = slider.negpos.response;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B4_symp = slider.symp.response;&lt;br/&gt;]&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black&lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ A_negpos = ""&lt;br/&gt;/ A1_negpos = ""&lt;br/&gt;/ A2_negpos = ""&lt;br/&gt;/ A3_negpos = ""&lt;br/&gt;/ A4_negpos = ""&lt;br/&gt;/ B_negpos = ""&lt;br/&gt;/ B1_negpos = ""&lt;br/&gt;/ B2_negpos = ""&lt;br/&gt;/ B3_negpos = ""&lt;br/&gt;/ B4_negpos = ""&lt;br/&gt;&lt;br/&gt;/ A_symp = ""&lt;br/&gt;/ A1_symp = ""&lt;br/&gt;/ A2_symp = ""&lt;br/&gt;/ A3_symp = ""&lt;br/&gt;/ A4_symp = ""&lt;br/&gt;/ B_symp = ""&lt;br/&gt;/ B1_symp = ""&lt;br/&gt;/ B2_symp = ""&lt;br/&gt;/ B3_symp = ""&lt;br/&gt;/ B4_symp = ""&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;summarydata&amp;gt;&lt;br/&gt;/ columns = (script.subjectid script.startdate script.starttime &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A_negpos values.A1_negpos values.A2_negpos values.A3_negpos values.A4_negpos&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B_negpos values.B1_negpos values.B2_negpos values.B3_negpos values.B4_negpos&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.A_symp values.A1_symp values.A2_symp values.A3_symp values.A4_symp&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.B_symp values.B1_symp values.B2_symp values.B3_symp values.B4_symp&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;values.sequence)&lt;br/&gt;/ separatefiles = true&lt;br/&gt;&amp;lt;/summarydata&amp;gt;&lt;br/&gt;&lt;br/&gt;</description><pubDate>Wed, 04 Mar 2020 16:14:34 GMT</pubDate><dc:creator>Dave</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28418.aspx</link><description>&lt;blockquote data-id="28417" class="if-quote-wrapper" unselectable="on" data-guid="1583337629127" contenteditable="false" id="if_insertedNode_1583337627554"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28417" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28417" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28417" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;Dave - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28417"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;&lt;blockquote data-id="28416" class="if-quote-wrapper" unselectable="on" data-guid="1583337629127" id="if_insertedNode_1583337449040" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28416" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28416" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28416" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28416"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;you kindly did help me with the following script and I have one more question concerning the data file: Now, the data are saved in long format (see file attached). However, I would like them to be saved like that:&lt;br/&gt;Collumns: subject, date, time, A_negpos, A1_negpos ... A_symp, A1_symp ..., values.sequence&lt;br/&gt;&lt;br/&gt;How can I do that?&lt;br/&gt;&lt;br/&gt;This is the script:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; values.item = list.items.nextvalue;&lt;br/&gt;&amp;nbsp; values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;&amp;nbsp; list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = false;&lt;br/&gt;&amp;nbsp; } else {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = true;&lt;br/&gt;&amp;nbsp; };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;&amp;nbsp; values.item = "";&lt;br/&gt;&amp;nbsp; values.sequence = "";&lt;br/&gt;&amp;nbsp; list.items.reset():&lt;br/&gt;&amp;nbsp; list.pages.reset();&lt;br/&gt;&amp;nbsp; list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;&amp;nbsp; if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false &lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;***************************************************** &lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black &lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Thank you a lot!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28416"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;You can create variables (i.e. &amp;lt;values&amp;gt;) capturing the data of interest and then write out a single-line (wide format) file via &amp;lt;summarydata&amp;gt;.&lt;a class="if-quote-goto quote-link" href="#" data-id="28417"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;I will have a try, thank you very much!</description><pubDate>Wed, 04 Mar 2020 16:00:50 GMT</pubDate><dc:creator>w.cao@uu.nl</dc:creator></item><item><title>RE: data in wide format</title><link>https://forums.millisecond.com/Topic28417.aspx</link><description>&lt;blockquote data-id="28416" class="if-quote-wrapper" unselectable="on" data-guid="1583337449686" id="if_insertedNode_1583337449040" contenteditable="false"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="28416" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="28416" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="28416" title=" "&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;mongrel - 3/4/2020&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-28416"&gt;&lt;div class="if-quote-message-margin" contenteditable="true"&gt;Hey Dave,&lt;br/&gt;&lt;br/&gt;you kindly did help me with the following script and I have one more question concerning the data file: Now, the data are saved in long format (see file attached). However, I would like them to be saved like that:&lt;br/&gt;Collumns: subject, date, time, A_negpos, A1_negpos ... A_symp, A1_symp ..., values.sequence&lt;br/&gt;&lt;br/&gt;How can I do that?&lt;br/&gt;&lt;br/&gt;This is the script:&lt;br/&gt;&lt;br/&gt;Slider*********************************************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;slider negpos&amp;gt;&lt;br/&gt;/ labels = ("negativ~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "positiv~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (22%, 50%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;slider symp&amp;gt;&lt;br/&gt;/ labels = ("unsympathisch~n1", "~n2", "~n3", "~n4", "~n5", "~n6", "sympathisch~n7")&lt;br/&gt;/ range = (1, 7)&lt;br/&gt;/ slidersize = (50%, 5%)&lt;br/&gt;/ showtooltips = false&lt;br/&gt;/ position = (19.5%, 75%)&lt;br/&gt;/ required = true&lt;br/&gt;/ fontstyle = ("Arial", 26, false)&lt;br/&gt;&amp;lt;/slider&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;image A&amp;gt;&lt;br/&gt;/ items = ("A.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B&amp;gt;&lt;br/&gt;/ items = ("B.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A1&amp;gt;&lt;br/&gt;/ items = ("A1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A2&amp;gt;&lt;br/&gt;/ items = ("A2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A3&amp;gt;&lt;br/&gt;/ items = ("A3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image A4&amp;gt;&lt;br/&gt;/ items = ("A4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B1&amp;gt;&lt;br/&gt;/ items = ("B1.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B2&amp;gt;&lt;br/&gt;/ items = ("B2.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B3&amp;gt;&lt;br/&gt;/ items = ("B3.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;image B4&amp;gt;&lt;br/&gt;/ items = ("B4.jpg")&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;/ imagesize = (33%,33%)&lt;br/&gt;&amp;lt;/image&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list items&amp;gt;&lt;br/&gt;/ items = ("A","A1","A2","A3","A4","B","B1","B2","B3","B4")&lt;br/&gt;/ selectionmode = random&lt;br/&gt;/ replace = false&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list pages&amp;gt;&lt;br/&gt;/ items = (surveypage.A,surveypage.A1,surveypage.A2,surveypage.A3,surveypage.A4,surveypage.B,surveypage.B1,surveypage.B2,surveypage.B3,surveypage.B4)&lt;br/&gt;/ selectionmode = list.items.currentindex&lt;br/&gt;/ selectionrate = trial&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ item = ""&lt;br/&gt;/ sequence = ""&lt;br/&gt;/ valid_sequence = false&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_generator&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; values.item = list.items.nextvalue;&lt;br/&gt;&amp;nbsp; values.sequence = concat(concat(values.sequence, ","), values.item);&lt;br/&gt;&amp;nbsp; list.mysequence.appenditem(list.pages.nextvalue);&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial sequence_checker&amp;gt;&lt;br/&gt;/ ontrialbegin = [&lt;br/&gt;&amp;nbsp; if (contains(values.sequence, "A,A1") || contains(values.sequence, "A1,A") || contains(values.sequence, "B,B1") || contains(values.sequence, "B1,B")) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = false;&lt;br/&gt;&amp;nbsp; } else {&lt;br/&gt;&amp;nbsp;&amp;nbsp;  values.valid_sequence = true;&lt;br/&gt;&amp;nbsp; };&lt;br/&gt;]&lt;br/&gt;/ validresponse = (0)&lt;br/&gt;/ trialduration = 0&lt;br/&gt;/ recorddata = false&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;expt&amp;gt;&lt;br/&gt;/ blocks = [1=generate_sequence; 2=run_sequence]&lt;br/&gt;&amp;lt;/expt&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block generate_sequence&amp;gt;&lt;br/&gt;/ onblockbegin = [&lt;br/&gt;&amp;nbsp; values.item = "";&lt;br/&gt;&amp;nbsp; values.sequence = "";&lt;br/&gt;&amp;nbsp; list.items.reset():&lt;br/&gt;&amp;nbsp; list.pages.reset();&lt;br/&gt;&amp;nbsp; list.mysequence.reset();&lt;br/&gt;]&lt;br/&gt;/ trials = [1-10=sequence_generator; 11=sequence_checker]&lt;br/&gt;/ branch = [&lt;br/&gt;&amp;nbsp; if (!values.valid_sequence) block.generate_sequence;&lt;br/&gt;]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;block run_sequence&amp;gt;&lt;br/&gt;/ trials = [1-10 = list.mysequence]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;list mysequence&amp;gt;&lt;br/&gt;/ selectionmode = sequence&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false &lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A3; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage A4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=A4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B1&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B2&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B1; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B3&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B2; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;surveypage B4&amp;gt;&lt;br/&gt;/ subcaption = "Wie wirkt diese Person auf Sie?"&lt;br/&gt;/ subcaptionfontstyle = ("Arial", 2.5%, true, false, false, false, 5, 0)&lt;br/&gt;/ showquestionnumbers = false&lt;br/&gt;/ questions = [1=B4; 2=negpos; 3=symp]&lt;br/&gt;/ finishlabel = "Weiter"&lt;br/&gt;/ nextbuttonposition = (47, 95)&lt;br/&gt;/ showbackbutton=false&lt;br/&gt;/ showpagenumbers = false&lt;br/&gt;/ branch = [trial.blank]&lt;br/&gt;&amp;lt;/surveypage&amp;gt;&lt;br/&gt;&lt;br/&gt;*****************************************************&lt;br/&gt;Blank between pages&lt;br/&gt;*****************************************************&lt;br/&gt;&amp;lt;trial blank&amp;gt;&lt;br/&gt;/stimulusframes = [1 = blank]&lt;br/&gt;/trialduration = 300&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item blank&amp;gt;&lt;br/&gt;/1 = "blank.png"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;picture blank&amp;gt;&lt;br/&gt;/ items = blank&lt;br/&gt;/ position = (37%, 15%)&lt;br/&gt;&amp;lt;/picture&amp;gt;&lt;br/&gt;&lt;br/&gt;***************************************************** &lt;br/&gt;*****************************************************&lt;br/&gt;Seitendesign&lt;br/&gt;*****************************************************&lt;br/&gt;&lt;br/&gt;&amp;lt;defaults&amp;gt;&lt;br/&gt;/canvasaspectratio = (4,3)&lt;br/&gt;/minimumversion = "5.0.0.0"&lt;br/&gt;/ fontstyle = ("Arial", 3%, false, false, false, false, 5, 1)&lt;br/&gt;/ screencolor = white&lt;br/&gt;/ txbgcolor = white&lt;br/&gt;/ txcolor = black &lt;br/&gt;/ halign = center&lt;br/&gt;&amp;lt;/defaults&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;data&amp;gt;&lt;br/&gt;/ columns = (date time subject group blocknum blockcode trialnum trialcode response correct latency values.sequence values.valid_sequence)&lt;br/&gt;/ separatefiles = false&lt;br/&gt;&amp;lt;/data&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Thank you a lot!!!&lt;br/&gt;R.&lt;br/&gt;&lt;br/&gt;&lt;a class="if-quote-goto quote-link" href="#" data-id="28416"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/blockquote&gt;&lt;br/&gt;You can create variables (i.e. &amp;lt;values&amp;gt;) capturing the data of interest and then write out a single-line (wide format) file via &amp;lt;summarydata&amp;gt;.</description><pubDate>Wed, 04 Mar 2020 15:58:21 GMT</pubDate><dc:creator>Dave</dc:creator></item></channel></rss>