<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
Hi Mits,
<div>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. </div>
<div><br>
</div>
<div>Kind regards,</div>
<div>Yvan</div>
<div><br>
<div><br>
<blockquote type="cite">
<div>On Sep 8, 2023, at 1:22 PM, Mits Ota <mits@ling.ed.ac.uk> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div>Hi Leonid,</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Best,</div>
<div><br>
</div>
<div>Mits<br>
</div>
<br>
<div class="gmail_quote">
<div dir="auto" class="gmail_attr">On Friday, September 8, 2023 at 4:10:26 PM UTC+1 Leonid Spektor wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div style="line-break:after-white-space">Hi Mits,
<div><br>
</div>
<div><span style="white-space:pre"></span>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.</div>
<div>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.<br>
<div>
<div style="font-family: Arial; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none;">
<br>
<br>
</div>
<div style="font-family: Arial; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none;">
Leonid.</div>
<div style="font-family: Arial; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none;">
<br>
</div>
<br>
</div>
<div><br>
<blockquote type="cite">
<div>On Sep 8, 2023, at 10:39, Mits Ota <<a href="" data-email-masked="" rel="nofollow">mi...@ling.ed.ac.uk</a>> wrote:</div>
<br>
<div>
<div>Dear chibolts,</div>
</div>
</blockquote>
</div>
</div>
</div>
<div style="line-break:after-white-space">
<div>
<div>
<blockquote type="cite">
<div>
<div><br>
</div>
<div>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:<br>
</div>
<div><br>
</div>
<div><span style="font-family:Courier New"> apple banana coconut<br>
</span></div>
<div><span style="font-family:Courier New">MOT 4 3 0<br>
</span></div>
<div><span style="font-family:Courier New">FAT</span> <span style="font-family:Courier New"> 2 0 19</span></div>
<div><span style="font-family:Courier New"> </span><br>
</div>
<div>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):<br>
</div>
<div><br>
</div>
<div><font face="Courier New">File Code Word Count</font></div>
<div><font face="Courier New">abc01 MOT apple 4</font></div>
<div><font face="Courier New">abc01 MOT banana 3</font></div>
<div><font face="Courier New">abc01 FAT apple 2</font></div>
<div><font face="Courier New">abc01 FAT coconut 19</font></div>
<div><font face="Courier New"><br>
</font></div>
<div>Any advice is welcome! Thanks.</div>
<div><br>
</div>
<div>Mits Ota<br>
</div>
<div><br>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div style="line-break:after-white-space">
<div>
<div>
<blockquote type="cite">
<div>-- <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="" data-email-masked="" rel="nofollow">chibolts+u...@googlegroups.com</a>.<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" rel="nofollow" data-saferedirecturl="https://www.google.com/url?hl=en&q=https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%2540googlegroups.com?utm_medium%3Demail%26utm_source%3Dfooter&source=gmail&ust=1694273954685000&usg=AOvVaw1BerxtmaVqZsJPsgETEJoT">
https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com</a>.<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<div><br class="webkit-block-placeholder">
</div>
-- <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>.<br>
</div>
</blockquote>
</div>
<br>
</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/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>.<br />