<div dir="ltr"><div>Hi</div><div><br></div><div>I've just written an R script which will do this. The output of the 'combo' command should be saved as a text file. The script reads this interactively using the 'scan' function. The tidyverse needs to be loaded (dplyr commands are used)<br></div><div><br></div><div>Here's the script:</div><div><br></div><div><br></div><div><br># Read in data interactively. File should be a text file.<br><br>options(stringsAsFactors = FALSE)<br><br>script <- scan(file.choose(), what = "string", sep = "\n")<br><br>df <- as.data.frame(script)<br><br># Create variable for type of line, e.g. "utt" = UTTERANCE, "mor" = MOR<br><br>df$type <- ""<br><br># Function for identifying 'mor' line (by searching for downpipes)<br><br>has_downpipe <- function(string){<br> return(grepl("[\x7C]" , string))<br>}<br><br>library(tidyverse)<br><br># Create variable showing line type (e.g. is it the 'mor' tier?)<br><br>for(i in 1:nrow(df)){<br> if(substr(df$script[i], 1, 8) == "*** File"){df$type[i] <- "file"}<br> if((substr(df$script[i], 1, 1) == "*") &<br> (substr(df$script[i], 5, 5) == ":")){df$type[i] <- "utt"}<br> if(has_downpipe(df$script[i])){df$type[i] <- "mor"}<br>}<br><br># Fill down 'utt' (utterance over more than one line)<br><br>for(i in 2:nrow(df)){<br> if(df$type[i] == "" & df$type[i - 1] == "utt"){df$type[i] == "utt"}<br>}<br><br># Remove non-essential lines and rename rows<br><br>df <- df[which(df$type != ""),]<br>row.names(df) <- seq(1, nrow(df))<br><br># Create variable for filename<br><br>df$file <- ""<br><br>for(i in 1:nrow(df)){<br> if(df$type[i] == "file"){<br> vector <- unlist(gregexpr("[\x22]", df$script[i]))<br> start <- vector[1] + 1<br> stop <- vector[2] - 1<br> df$file[i] <- substr(df$script[i], start, stop)<br> }<br>}<br><br># Create variables of utterance and mor line<br><br>df$utt <- ""<br>df$mor <- ""<br><br>file_row <- 1<br><br>for(i in 1:nrow(df)){<br> if(df$type[i] == "file"){file_row <- i}<br> if(df$type[i] == "utt"){df$utt[file_row] <- paste(df$utt[file_row], df$script[i])}<br> if(df$type[i] == "mor"){df$mor[file_row] <- paste(df$mor[file_row], df$script[i])}<br>}<br><br># Remove blank lines and rename rows<br><br>df <- df[which(df$file != ""),]<br>row.names(df) <- seq(1, nrow(df))<br><br># Drop unnecessary variables<br><br>df <- df %>% select(file, utt, mor)<br><br></div><br>On Thursday, August 16, 2018 at 4:26:12 PM UTC+1, Davida wrote:<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"><div dir="ltr"><div>Nick,</div><div><br></div><div>Right, +d6 gives you # of matches in a spreadsheet but without the
individual utterance. You will probably have to use one of the other +d
options (probably 1, 2, or 3) to check individual utterances. You can
always consider copying and pasting that output to a spreadsheet (or
another tab your other combo results spreadsheet).</div><div><br></div><div>-Davida<br></div><br><div><br><div class="gmail_quote">On Thu, Aug 16, 2018 at 11:09 AM, Nick Riches <span dir="ltr"><<a href="javascript:" target="_blank" gdf-obfuscated-mailto="hQLEnmmLDwAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">nick....@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Thanks - very simple!<br><br>I now have the +d6 switch. But it doesn't quite do what I am looking for, as it doesn't list each individual utterance in the database for checking</div><div><br></div><div>Nick<br></div><span><br>On Thursday, August 16, 2018 at 1:16:16 PM UTC+1, Davida wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span>Nick,<div><br></div><div>Is it possible you're using an older version of CLAN (the date should appear in the lower left corner of the Commands window next to the <i>Recall</i> button)? Consider downloading a new version and you should see the option and it should work. </div><div><br></div></span><div>-Davida<br><div><br><div class="gmail_quote"><span>On Thu, Aug 16, 2018 at 3:24 AM, Nick Riches <span dir="ltr"><<a rel="nofollow">nick....@gmail.com</a>></span> wrote:<br></span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span><div dir="ltr"><div>Thanks for the reply<br></div><div><br></div><div>For COMBO, the +d switches only go from 1 - 5, so it doesn't look as if this will work.</div><div><br></div><div>Best wishes</div><div><br></div><div>Nick<br></div><span><div><br></div><br>On Wednesday, August 15, 2018 at 2:06:06 PM UTC+1, Davida wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"><span><div dir="ltr"><span style="font-size:12.8px;float:none;display:inline">Dear Nick,</span><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Did you try the +d6 switch? You can always see a list and explanation of the options and switches if you just type the command (in this case, combo) in the command window and then hit return. <br></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Hope that helps,</div><div style="font-size:12.8px">Davida</div><br></div></span><div><br><div class="gmail_quote"><span>On Wed, Aug 15, 2018 at 5:47 AM, Nick Riches <span dir="ltr"><<a rel="nofollow">nick....@gmail.com</a>></span> wrote:<br></span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span><div dir="ltr"><div>Hi</div><div><br></div><div>I'm trying to output the results of a COMBO search to an Excel file (e.g. with one column for a file identifier, another column for the participant, a third column the speaker tier, and a fourth column for the MOR tier). I understand that many commands have switches which allow output to a spreadsheet format, but I cannot find an equivalent for the COMBO command. Is there one?</div><div><br></div><div>Thanks<span><font color="#888888"><br></font></span></div></div></span><span><font color="#888888"><span>
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br></span>
To unsubscribe from this group and stop receiving emails from it, send an email to <a rel="nofollow">chibolts+u...@googlegroups.com</a><wbr>.<br>
To post to this group, send email to <a rel="nofollow">chib...@googlegroups.com</a>.<span><br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/989cf490-ee50-49f2-943e-ad24b43200fe%40googlegroups.com?utm_medium=email&utm_source=footer" rel="nofollow" target="_blank" onmousedown="this.href='https://groups.google.com/d/msgid/chibolts/989cf490-ee50-49f2-943e-ad24b43200fe%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;" onclick="this.href='https://groups.google.com/d/msgid/chibolts/989cf490-ee50-49f2-943e-ad24b43200fe%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;">https://groups.google.com/d/<wbr>msgid/chibolts/989cf490-ee50-<wbr>49f2-943e-ad24b43200fe%<wbr>40googlegroups.com</a>.<br>
For more options, visit <a href="https://groups.google.com/d/optout" rel="nofollow" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/<wbr>optout</a>.<br>
</span></font></span></blockquote></div><br></div>
</blockquote></div><span>
<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 rel="nofollow">chibolts+u...@googlegroups.com</a><wbr>.<br>
To post to this group, send email to <a rel="nofollow">chib...@googlegroups.com</a>.<br></span></span><span>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/1e72f879-f6af-4343-9c99-3e09afdd1229%40googlegroups.com?utm_medium=email&utm_source=footer" rel="nofollow" target="_blank" onmousedown="this.href='https://groups.google.com/d/msgid/chibolts/1e72f879-f6af-4343-9c99-3e09afdd1229%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;" onclick="this.href='https://groups.google.com/d/msgid/chibolts/1e72f879-f6af-4343-9c99-3e09afdd1229%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;">https://groups.google.com/d/<wbr>msgid/chibolts/1e72f879-f6af-<wbr>4343-9c99-3e09afdd1229%<wbr>40googlegroups.com</a>.<div><div><br>
For more options, visit <a href="https://groups.google.com/d/optout" rel="nofollow" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/<wbr>optout</a>.<br>
</div></div></span></blockquote></div><br></div></div></div>
</blockquote></div><span>
<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="javascript:" target="_blank" gdf-obfuscated-mailto="hQLEnmmLDwAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">chibolts+u...@<wbr>googlegroups.com</a>.<br>
To post to this group, send email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="hQLEnmmLDwAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">chib...@googlegroups.com</a>.<br></span>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/1345fdaa-077a-4088-b4b8-a4a2cd374538%40googlegroups.com?utm_medium=email&utm_source=footer" target="_blank" rel="nofollow" onmousedown="this.href='https://groups.google.com/d/msgid/chibolts/1345fdaa-077a-4088-b4b8-a4a2cd374538%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;" onclick="this.href='https://groups.google.com/d/msgid/chibolts/1345fdaa-077a-4088-b4b8-a4a2cd374538%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter';return true;">https://groups.google.com/d/<wbr>msgid/chibolts/1345fdaa-077a-<wbr>4088-b4b8-a4a2cd374538%<wbr>40googlegroups.com</a>.<div><div><br>
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/<wbr>optout</a>.<br>
</div></div></blockquote></div><br></div></div>
</blockquote></div>
<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 post to this group, send email to <a href="mailto:chibolts@googlegroups.com">chibolts@googlegroups.com</a>.<br />
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/c8b3328e-efd6-4c83-8b3b-f59e083809bf%40googlegroups.com?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/c8b3328e-efd6-4c83-8b3b-f59e083809bf%40googlegroups.com</a>.<br />
For more options, visit <a href="https://groups.google.com/d/optout">https://groups.google.com/d/optout</a>.<br />