<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><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>I have added +d20 option to FREQ to produce spreadsheet output you wanted. Please, get new version of CLAN.<div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Arial; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><br></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Arial; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;">Leonid.</div>
</div>
<div><br><blockquote type="cite"><div>On Sep 8, 2023, at 11:52, 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 write 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/A2A6A45E-8ADE-4EFE-AC92-7C1791D137BC%40andrew.cmu.edu?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/A2A6A45E-8ADE-4EFE-AC92-7C1791D137BC%40andrew.cmu.edu</a>.<br />