FREQ outputs in long format

[Leonid Spektor]

Hi Mits,

	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.
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.


Leonid.



> On Sep 8, 2023, at 10:39, Mits Ota <mits at ling.ed.ac.uk> wrote:
> 
> Dear chibolts,
> 
> 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:
> 
>      apple  banana coconut
> MOT    4       3      0
> FAT     2       0      19
>     
> 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):
> 
> File  Code  Word  Count
> abc01 MOT   apple    4
> abc01 MOT   banana   3
> abc01 FAT   apple    2
> abc01 FAT   coconut  19
> 
> Any advice is welcome! Thanks.
> 
> Mits Ota
> 
> -- 
> You received this message because you are subscribed to the Google Groups "chibolts" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com <mailto:chibolts+unsubscribe at googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com <https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com?utm_medium=email&utm_source=footer>.

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/78109D40-660D-441F-B69C-92A7ECFC72B6%40andrew.cmu.edu.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20230908/a07b4362/attachment.htm>