+d2 to columns not rows

Jocelyn Marzan jcbmarzan at post.upm.edu.ph
Tue Apr 24 10:47:10 UTC 2012


I  would like to thank Leonid for uploading a new version of CLAN that
solved the problem. The following worked beautifully:

---------- Forwarded message ----------
From: Leonid Spektor <spektor at andrew.cmu.edu>
Date: Tue, Apr 24, 2012 at 6:02 PM
Subject: Re: +d2 to columns not rows
To: Jocelyn Marzan <jcbmarzan at post.upm.edu.ph>


Joyce,

Command "spreadsheet stat.frq.xls" create a new Excel file called
"stat.frq.spread.xls". That is the file you need to open with your Excel
2002 application.

Leonid.


Joyce M
------------------------------------------------------------
JOCELYN MARZAN, MA, CCC-SLP
Associate Professor
Department of Speech Pathology
College of Allied Medical Professions
University of the Philippines Manila
UP Manila Compound, Pedro Gil Street,
Malate, Manila 1004, Philippines

Phone: (632) 5267125
Telefax: (632) 5262271




On Tue, Apr 24, 2012 at 1:23 AM, Leonid Spektor <spektor at andrew.cmu.edu>wrote:

> Joyce,
>
> CLAN will have a SPREADSHEET command by the end of today, that will rotate
> any CLAN spreadsheet output on its side, turning columns into row and vice
> versa.
>
> Leonid.
>
>
>
> On Apr 22, 2012, at 22:42 , Joyce Marzan wrote:
>
> Hi!
>
> am now integrating lexical data across CHAT files... want to come up with
> a "LEXICON x AGE" table extracted from 10-15 CHAT files... the "freq +d2
> +t*CHI *.cha" does this beautifully, but it outputs the lexical items in
> columns. I am afraid I am using MS Excel 2002 which has a maximum of  256
> columns, but 65536 rows... is there a way to get the lexical data in rows
> instead of columns? attached is the output file (kindly ignore other
> issues... i realize i need my team to fix our headers... :-)
>
> Thank you!
>
> Joyce
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "chibolts" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/chibolts/-/ArYyefv1DgIJ.
> To post to this group, send email to chibolts at googlegroups.com.
> To unsubscribe from this group, send email to
> chibolts+unsubscribe at googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/chibolts?hl=en.
> <stat.frq.xls>
>
>
>  --
> You received this message because you are subscribed to the Google Groups
> "chibolts" group.
> To post to this group, send email to chibolts at googlegroups.com.
> To unsubscribe from this group, send email to
> chibolts+unsubscribe at googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/chibolts?hl=en.
>

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To post to this group, send email to chibolts at googlegroups.com.
To unsubscribe from this group, send email to chibolts+unsubscribe at googlegroups.com.
For more options, visit this group at http://groups.google.com/group/chibolts?hl=en.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20120424/9516555a/attachment.htm>


More information about the Chibolts mailing list