Exporting Results to Excel with a .cut file

[Sabrina Huang]

Has anyone has successfully exported results to excel when using a .cut file?

[Leonid Spektor]

The short answer is maybe. For a more precise answer please specify whether you are analyzing the .cut file itself or using it as include file with +s...@file.cut option. Also, please say which CLAN command you are trying to get Excel output from. Not all CLAN commands are capable of creating Excel output.

Leonid.

On Apr 26, 2019, at 16:13, Sabrina Huang <sabh...@bu.edu> wrote:

Has anyone has successfully exported results to excel when using a .cut file?

--
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+u...@googlegroups.com.
To post to this group, send email to chib...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/9deeee4e-e572-41af-87ac-981ab9ce7a8e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Sabrina Huang]

Hi Leonid,

I am trying to do freq +d +...@file.cut @

Thanks!

Best,

Sabrina

On Friday, April 26, 2019 at 5:03:25 PM UTC-4, Leonid Spektor wrote:

The short answer is maybe. For a more precise answer please specify whether you are analyzing the .cut file itself or using it as include file with +s...@file.cut option. Also, please say which CLAN command you are trying to get Excel output from. Not all CLAN commands are capable of creating Excel output.

Leonid.

On Apr 26, 2019, at 16:13, Sabrina Huang <sabh...@bu.edu> wrote:

Has anyone has successfully exported results to excel when using a .cut file?

--
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 chib...@googlegroups.com.

[Leonid Spektor]

Sabrina,

There is no way to have the output of +d option presented in Excel format. The Excel spreadsheet is two dimensional with columns for words and rows for number of times that word is used by each speaker, i.e. one speaker per row. The +d option creates a three dimensional output with words, number of times that word is used and the line numbers each word is located on in a file. The only way to fit all of this into Excel output is to have each cell, which is an intersection of each word and speaker's row, consist of the number of times that word was used by that speaker along with all the line numbers that word occurs on. Then each cell will be very crowded with lots of text.

If, however, I misunderstood your question and you do not want to get +d option's output, then to create basic Excel output you would type command:

freq +d2 +s...@file.cut @

or

freq +d3 +s...@file.cut @

Leonid.

On Apr 26, 2019, at 18:52, Sabrina Huang <sabh...@bu.edu> wrote:

Hi Leonid,

I am trying to do freq +d +s...@file.cut @

To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+u...@googlegroups.com.

To post to this group, send email to chib...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/c6f38ac0-cfff-4621-80b1-766cded010a5%40googlegroups.com.