Category:SketchEngine: Difference between revisions

Latest revision as of 17:45, 22 July 2018

Go to SketchEngine Concordance search
Download as CSV and import CSV to Google Spreadsheet or Excel (Use [1] to convert to other formats)
1. Use a formula like: ="## ''"&A2&" '''[["&B2&"]]''' "&C2&" ["&D2&"]" or =="## '' "&B5&" [["&C5&"]] "&D5&" ["&A5&"]"
2. Optionally shorten sentences at https://regexr.com/3spr3 and https://regexr.com/3sqk7 (Replacement: $1'''[[$2]]'''$3\n)
Add top 3 to word page and the rest to it's own wordpage/examples

This category has only the following subcategory.

The following 13 pages are in this category, out of 13 total.

@@ Line 2: / Line 2: @@
 # Go to [https://app.sketchengine.eu/#concordance SketchEngine Concordance search]
 # Download as CSV and import CSV to [https://docs.google.com/spreadsheets/u/0/ Google Spreadsheet] or [https://onedrive.live.com/ Excel] (Use [https://codebeautify.org/xml-to-csv-converter] to convert to other formats)
-## Use a formula like: <code><nowiki>="## ''"&A2&" '''[["&B2&"]]''' "&C2&" ["&D2&"]"</nowiki></code>
+## Use a formula like: <code><nowiki>="## ''"&A2&" '''[["&B2&"]]''' "&C2&" ["&D2&"]"</nowiki></code> or <code><nowiki>=="## '' "&B5&" [["&C5&"]] "&D5&" ["&A5&"]"</nowiki></code>
-## Optionally shorten sentences at https://regexr.com/3spr3
+## Optionally shorten sentences at https://regexr.com/3spr3 and https://regexr.com/3sqk7 (Replacement: <code><nowiki>$1'''[[$2]]'''$3\n</nowiki></code>)
-# Add top 3 to word page and the rest to word/examples
+# Add top 3 to word page and the rest to it's own [[wordpage/examples]]