<html><head><meta http-equiv="content-type" content="text/html; charset=us-ascii"></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>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="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-stroke-width: 0px; text-decoration: none;"><br class="Apple-interchange-newline"><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-stroke-width: 0px; text-decoration: none;">Leonid.</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-stroke-width: 0px; text-decoration: none;"><br></div><br class="Apple-interchange-newline">
</div>
<div><br><blockquote type="cite"><div>On Sep 8, 2023, at 10:39, Mits Ota <mits@ling.ed.ac.uk> wrote:</div><br class="Apple-interchange-newline"><div><div>Dear chibolts,</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 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/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%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/78109D40-660D-441F-B69C-92A7ECFC72B6%40andrew.cmu.edu?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/78109D40-660D-441F-B69C-92A7ECFC72B6%40andrew.cmu.edu</a>.<br />