More actions
Replaced content with "Category:TODO # Go to [https://app.sketchengine.eu/#concordance SketchEngine Concordance search] # Download as CSV and import CSV to [https://docs.google.com/spreadshe..." Tag: Replaced |
No edit summary |
||
| Line 2: | Line 2: | ||
# Go to [https://app.sketchengine.eu/#concordance SketchEngine Concordance search] | # 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) | # 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 | # Add top 3 to word page and the rest to it's own [[wordpage/examples]] | ||