<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I have achieved this via Excel as Yvan says:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Paste into Excel (Paste Special, using the Transpose option).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">It will probably paste all into one column so then I do
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Data – Text to Columns (usually Fixed format works better than Delimited, but Delimited with Spaces as delimiter sometimes works).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Katie<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Dr Katie Alcock, DPhil, CPsychol</span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Department of Psychology,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Fylde College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Lancaster University
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Bailrigg<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Lancaster <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">LA1 4YF<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Please note working pattern: Monday through Thursday. I am unavailable on Fridays, and I am currently at Stanford so am unlikely to answer emails during UK working hours.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Out now: UK Communicative Development Inventories (Words and Gestures)<br>
<a href="https://www.jr-press.co.uk/uk-communicative-development-inventories.html">https://www.jr-press.co.uk/uk-communicative-development-inventories.html</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> chibolts@googlegroups.com <chibolts@googlegroups.com>
<b>On Behalf Of </b>Rose, Yvan<br>
<b>Sent:</b> Friday, September 8, 2023 9:18 AM<br>
<b>To:</b> chibolts@googlegroups.com<br>
<b>Subject:</b> [External] Re: FREQ outputs in long format<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><strong><span style="font-family:"Calibri",sans-serif;color:#A4343A">This email originated outside the University. Check before clicking links or attachments.</span></strong><o:p></o:p></p>
<div>
<p class="MsoNormal">Hi Mits, <o:p></o:p></p>
<div>
<p class="MsoNormal">I believe that a basic 'transpose' operation in the spreadsheet of your choice would address this issue. Please send me a personal message if you want more input about this. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Kind regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Yvan<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On Sep 8, 2023, at 1:22 PM, Mits Ota <<a href="mailto:mits@ling.ed.ac.uk">mits@ling.ed.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi Leonid,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks for the reply. I suspect that much; otherwise I would have expected to see a relevant option already available on CLAN :-). I don't have enough XML skills to wirte a utility, so for now I'm just going to reshape the current output
format on R, but it would be nice to have that option in CLAN in the future if the powers to be are willing to give their blessing.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mits<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Friday, September 8, 2023 at 4:10:26 PM UTC+1 Leonid Spektor wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Hi Mits, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">There is no way to reformat FREQ output the way you want it right now. FREQ can be changed fairly easily to produce this kind of output, but this would have to be approved by the powers that be.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">The other alternative is for someone else to write a utility to reformat FREQ spreadsheet output the way you want it. The FREQ spreadsheet output is in XML format, so it should be easy to do.<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Leonid.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On Sep 8, 2023, at 10:39, Mits Ota <<span class="MsoHyperlink">mi...@ling.ed.ac.uk</span>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Dear chibolts,<o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div>
<div>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Does anyone know how to send out FREQ outputs in a long spreadsheet format? By default, spreadsheet outputs of FREQ come out in a wide format with speakers in rows but words across columns, like this:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> apple banana coconut</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">MOT 4 3 0</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">FAT</span> <span style="font-family:"Courier New""> 2 0 19</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I would like to obtain spreadsheet outputs for FREQ in which each row is a unique entry defined by the filename, speaker, word, and its frequency (like KWAL spreadsheet output):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">File Code Word Count</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">abc01 MOT apple 4</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">abc01 MOT banana 3</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">abc01 FAT apple 2</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">abc01 FAT coconut 19</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Any advice is welcome! Thanks.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mits Ota<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div>
<div>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to
<span class="MsoHyperlink">chibolts+u...@googlegroups.com</span>.<br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com?utm_medium=email&utm_source=footer" target="_blank">
https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com</a>.<o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</blockquote>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to
<a href="mailto:chibolts+unsubscribe@googlegroups.com">chibolts+unsubscribe@googlegroups.com</a>.<br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/ef67a624-286e-42fb-8e1d-a05682a40ccfn%40googlegroups.com?utm_medium=email&utm_source=footer">
https://groups.google.com/d/msgid/chibolts/ef67a624-286e-42fb-8e1d-a05682a40ccfn%40googlegroups.com</a>.<o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to
<a href="mailto:chibolts+unsubscribe@googlegroups.com">chibolts+unsubscribe@googlegroups.com</a>.<br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/21EFA9B8-6CE5-43BF-92F3-99F082350C7A%40mun.ca?utm_medium=email&utm_source=footer">
https://groups.google.com/d/msgid/chibolts/21EFA9B8-6CE5-43BF-92F3-99F082350C7A%40mun.ca</a>.<o:p></o:p></p>
</div>
</div>
</body>
</html>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "chibolts" group.<br />
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:chibolts+unsubscribe@googlegroups.com">chibolts+unsubscribe@googlegroups.com</a>.<br />
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/LO4P265MB6171239AEA2AF3DD39451E9A9FC3A%40LO4P265MB6171.GBRP265.PROD.OUTLOOK.COM?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/LO4P265MB6171239AEA2AF3DD39451E9A9FC3A%40LO4P265MB6171.GBRP265.PROD.OUTLOOK.COM</a>.<br />