Nitpick away, Michiel. <br><br>I appreciate the additional information and advice. <br><br>Thanks!<br><br><div class="gmail_quote">On Wed, Feb 13, 2013 at 7:54 AM, Cognitology <span dir="ltr"><<a href="mailto:mspape@cognitology.eu" target="_blank">mspape@cognitology.eu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi,<u></u><u></u></span></p><p class="MsoNormal">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Just to nitpick and maybe future help: <u></u><u></u></span></p><p><u></u><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Excel-files do not store ascii. I suspect you mean you exported from Excel to tab-delimited text file (as you actually say a bit later on). This is important because it probably means that something in the conversion went awry. <u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The quotation marks are quite unlikely to appear random unless you run Office for Quantum Computer. A quotation mark can appear if a number in excel, stored in a “general format” cell, is to be treated as text: I.e. 128 is a number, ‘128 are three letters. The trick is to accurately set the cell format, or:<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Open .txt (or whatever the file is) in notepad, hit CONTROL+H, enter replace [‘] to [] (i.e. one quotation mark to nothing), save. Sounds dumb, but I love doing it this way, same goes for converting stuff to SPSS. This should not mess up the columns.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Best,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Michiel<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a> [mailto:<a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>] <b>On Behalf Of </b>Justine VanDyke<br>
<b>Sent:</b> 12. February 2013 23:08<br><b>To:</b> <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a><br><b>Subject:</b> Re: Quotation marks in stimulus .txt file<u></u><u></u></span></p>
</div><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<br><br>Thanks for your reply. To clarify:<br><br>-yes, I have text in an Excel file. <br><br>-yes, randomly quotation marks occur around certain words (not present in the Excel file).<br>
<br>-this occurs when I 'Save As' a .txt file. <br><br>-yes, I am 'loading' a file using Load Method "File".<br><br>-yes, certain words (meaning 'some') have quotations. <br><br>Apologies that that wasn't clear. <br>
<br>I solved the problem by copying and pasting from Excel into a .txt file; however, it's good to know that this is not necessary and that I can load directly from Excel.<br><br>Many thanks. <u></u><u></u></p><div><p class="MsoNormal">
On Tue, Feb 12, 2013 at 3:06 PM, David McFarlane <<a href="mailto:mcfarla9@msu.edu" target="_blank">mcfarla9@msu.edu</a>> wrote:<u></u><u></u></p><p class="MsoNormal">Justine,<br><br>I am having a bit of trouble following this. Do you mean that<br>
- you have text in an Excel file<br>- the text in the Excel file does not contain any quotation marks<br>- you convert the Excel file to a .txt file (how do you do that?)<br>- the resulting .txt file now has quotation marks around some (all?) of the text<br>
- you use the .txt file as input to an EP List (using Load Method "File")<br>- and now (some? all?) the text stimuli are enclosed in quotation marks?<br><br>Please clarify.<br><br>BTW, if you use EP2.0.10.x or later, a List can load from an Excel file directly, no need to convert it to .txt first.<br>
<br>-----<br>David McFarlane<br>E-Prime training online: <a href="http://psychology.msu.edu/Workshops_Courses/eprime.aspx" target="_blank">http://psychology.msu.edu/Workshops_Courses/eprime.aspx</a><br>Twitter: @EPrimeMaster (<a href="https://twitter.com/EPrimeMaster" target="_blank">https://twitter.com/EPrimeMaster</a>)<br>
<br>/----<br>Stock reminder: 1) I do not work for PST. 2) PST's trained staff take any and all questions at <a href="http://support.pstnet.com/e%2Dprime/support/login.asp" target="_blank">http://support.pstnet.com/e%2Dprime/support/login.asp</a> , and they strive to respond to all requests in 24-48 hours, so make full use of it. 3) In addition, PST offers several instructional videos on their YouTube channel (<a href="http://www.youtube.com/user/PSTNET" target="_blank">http://www.youtube.com/user/PSTNET</a> ). 4) If you do get an answer from PST staff, please extend the courtesy of posting their reply back here for the sake of others.<br>
\----<u></u><u></u></p><div><p class="MsoNormal"><br><br><br><br>At 2/12/2013 02:27 PM Tuesday, you wrote:<u></u><u></u></p><p class="MsoNormal">Hello,<br><br>I have a .txt ffile that I am loading stimuli from in an E-Prime experiment. The stimuli consist of sentences (text). During experimental presentation, randomly, quotation marks appear around certain words that are not present on the Excel file from which I have created the .txt. I assume this is something to do with saving in the tab-delimited format, and I wondered whether anyone has a solution.<br>
<br>If I simply delete the quotations from the .txt file, then I am concerned that I will mess up the tab-structure.<br><br>Thanks,<br><br>Justine VanDyke<br>Postdoctoral Research Assistant<br>Language Processing Lab<br>Institute for Mind and Brain<br>
University of South Carolina<u></u><u></u></p><p class="MsoNormal"><br>-- <br>You received this message because you are subscribed to the Google Groups "E-Prime" group.<br>To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:e-prime%2Bunsubscribe@googlegroups.com" target="_blank">e-prime+unsubscribe@googlegroups.com</a>.<br>
To post to this group, send email to <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>.<u></u><u></u></p></div><div><div><p class="MsoNormal" style="margin-bottom:12.0pt">For more options, visit <a href="https://groups.google.com/groups/opt_out" target="_blank">https://groups.google.com/groups/opt_out</a>.<br>
<br><u></u><u></u></p></div></div></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">-- <br>You received this message because you are subscribed to the Google Groups "E-Prime" group.<br>To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:e-prime+unsubscribe@googlegroups.com" target="_blank">e-prime+unsubscribe@googlegroups.com</a>.<br>
To post to this group, send email to <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>.<br>For more options, visit <a href="https://groups.google.com/groups/opt_out" target="_blank">https://groups.google.com/groups/opt_out</a>.<br>
<br> <u></u><u></u></p></div></div></div></div><div class="HOEnZb"><div class="h5">
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups "E-Prime" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:e-prime%2Bunsubscribe@googlegroups.com" target="_blank">e-prime+unsubscribe@googlegroups.com</a>.<br>
To post to this group, send email to <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>.<br>
For more options, visit <a href="https://groups.google.com/groups/opt_out" target="_blank">https://groups.google.com/groups/opt_out</a>.<br>
<br>
<br>
</div></div></blockquote></div><br>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "E-Prime" group.<br />
To unsubscribe from this group and stop receiving emails from it, send an email to e-prime+unsubscribe@googlegroups.com.<br />
To post to this group, send email to e-prime@googlegroups.com.<br />
For more options, visit <a href="https://groups.google.com/groups/opt_out">https://groups.google.com/groups/opt_out</a>.<br />
<br />
<br />