̾Ų2020ѥܸ

2020ǯ923()

13¡ ȥ/ܸ쥳ѥξҲ

ȥ

γǧ

ǼץȤˤĤ

ȤѤʥեȥWebץꥱͽ

եȥμࡦ̾Ū
ѥץꥱǼѥθ
ɽ׻եExcelԥܥåȥơ֥ˤʬϡպ
ץWord֥פѤݡȺ
WebޤDz
ƥȥǥ 饨ǥɽȤäƥȤθ
ʸեҤޤǡθ
Rǡʬ

ƥǥ

24¡ ѥ߷

ѥȤ

Υѥ
츦ŪȤƼ졢츦Τξդ줿ԥ塼Ѳǽ絬Ϥʸǡ
  • ܸ񤭸նѹեѥBCCWJ / ܸ˥ѥCHJ
Υѥ
ԥ塼Ѳǽ絬Ϥʸǡɬ츦ǤϤʤ츦Ѳǽ

λ饳ѥޤ (ܸ츦)

  1. ()ʸ
  2. ()ʥ󥳡󥹡
  3. ƼŻҥƥ
  4. ¤ƥ
  5. դѥ

ѥ˵

ָܸ񤭸նѹեѥסBCCWJˤιȥץ

ܸ˥ѥסCHJˤι

ͥ

35¡ ѥηȷDz

ѥη

ѥؤηͿ

DzϡMecabפȡUniDic

DzϤȤ

morph.png

Dzѥեȥ

ȤƤ륽եȥ

ޤʲѤΤġ

UniDicĹ

  1. Ф줬ûñȤưñ̤·Ƥ
  2. Ф줬زƤɽɤѰۤˤ餺ƱθФͿ뤳ȤǤ
  3. Ȥ䲻ѲξͿ뤳ȤǤ
  4. ʤɸ츦Τ˭٤ʾͿƤ

ǶηDzϴ

Ĺñ̲ϴ

ϴ

ܸ쥳ѥΥդΥ٥

ƥȤΥ٥ġɬפʵ
ץ졼ƥƥȥǥgrepɽ
¤ƥҤޤꢪ ExcelXMLޡåפδáԥܥåȥơ֥
DzϺѤUniDic+MeCabǼChaKiDzϤμChaKiλȤ
դ+CaboChaʤɢChaKi
  1. ץ졼ƥȡƥȥǥgrepɽ
  2. ¤ƥȡʵۥѥפʤɡˡXMLȡ֤Ҥޤ
  3. DzϺѤߥƥȡBCCWJCHJʤɡˡǼ
  4. դNWJC,NPCMJʤɡˡChaKi, NPCMJ Searchʤ

2020ǯ924()

42¡ Ǽ٤λȤʴá

Ѥ

53¡ Ǽ٤λȤ

: (ʻ LIKE "ƻ%" AND ѷ LIKE "Ϣη%")
 AND : ="" ON 1 WORDS FROM 
 WITH OPTIONS tglKugiri="|" AND tglBunKugiri="#" AND limitToSelfSentence="1"
AND tglFixVariable="2" AND tglWords="20" AND unit="1" AND encoding="UTF-16LE" AND endOfLine="CRLF"

ήRemo

64¡ ̤νסExcelȥԥܥåȥơ֥

Ǽ׸̤ΥɤExcelǤ

  1. ֤Ÿʲ
  2. Excelǥݡ

Excelδ

ڽסۥԥܥåȥơ֥λȤ

75¡

ָ

ڽۥݡȥơޤˤĤ

*1

2020ǯ925()

82¡ äȤ

ʣθ̤η

硼ȥåȥѤ

  1. ɽ򥳥ԡ
    • Ctrl+Home, ̾ϥԡʤ褦ˤ,Shift+Ctrl+End, Ctrl+C
  2. ԡɽ¸ɽβŽդ
    • Ctrl+, , Ctrl+V, Ctrl+Home

硼ȥåȥ

ѤʬѰդ

ॵץĴ

93¡ BCCWJѤ

иץĴʽʣκ

ǤϤʤ㤬ĤǤиץοĴ٤

BCCWJѤȤ

Ĵ٤η׻

104¡ˡפΤαѡʸؿ

­CHJǤ

Excelʸؿ

115¡ˡפΤα2VLOOKUPؿ

ʻ͡åסZipfˤˡ§

VLOOKUPѤ

­ˡǼץ饤󥿥ǽ

2020ǯ928()

ݡȥơޤӼˤĤơNUCT

122¡ ƥȥǥɽ

ƥȥǡ

ƥȥǥ

饨ǥΥɤȥ󥹥ȡ

MacξmiΥɤȥ󥹥ȡ

ƥȥǥȤäƤߤ

grepִKWIC(CSVե)ʴʰǡ

ɽȤäƤߤ

133¡ ɽ

ɽȤ

ɽΤ

ɽα

դɽ

Ĺפθ§greedy matching

ʸǤθ

ɽ˴ؤ뻲ͻ

ʻ͡˥ƥȥǡĶʸˡˤ

144¡ Excel / ʤѤ˸

ΥơǡVLOOKUP

ѥθɽ

ħ

R

155¡ ݡȤν 䥳ʡ

WordǥݡȤ

ʸι¤WordλȤʥݡȤν

Ǥ夲Remo


*1 ºݤ˸ƤߤƤǤʤΤ񤷤ʤΤޤޤƤޤ
*2 ǿǤMeCabǤΤ

ȥå   Խ ʬ Хåå ź ʣ ̾ѹ   ǽ   إ   ǽRSS
Last-modified: 2020-09-28 () 18:09:56