Slide 1

Slide 1 text

ϊϯϓϩάϥϚʔͷ ϓϩάϥϛϯά׆༻๏ The Non-Programmer's Programming Techniques ໳দ޺໌ / @note103

Slide 2

Slide 2 text

໨࣍ 1. ࣗݾ঺հ / ൃදझࢫ 2. ׆༻ࣄྫ 1. Vim 2. Shell 3. Perl 4. Excel 3. ;ΓฦΓ / ·ͱΊ 2

Slide 3

Slide 3 text

ࣗݾ঺հ • ໳দ޺໌ / @note103 • 1975ʙ • ฤूऀ • commmons: schola ʢίϞϯζɾείϥʣ • ࡔຊཾҰ؂मʹΑΔԻָશूʢ2008ʙʣ 3

Slide 4

Slide 4 text

commmons: schola • CDϒοΫͷԻָશू • ࡔຊཾҰ͕ݹࠓ౦੢ͷ Իָ͔Β໊ԋΛݫબ͠ CDऩ࿥ • ෇ଐϒοΫϨοτP120 • ࠲ஊձ • ղઆจ • ೥ද etc. 4

Slide 5

Slide 5 text

৽ץ৘ใ commmons: schola • 2018/03/21 ୈ17ר ൃച!! • ςʔϚ͸ϩϚϯ೿Իָ • γϣύϯɺγϡʔϚϯɺ
 ϫʔάφʔɺϒϥʔϜεɺ
 ϑΥʔϨɺϚʔϥʔ etc. 5

Slide 6

Slide 6 text

ϓϩάϥϛϯάೖ໳ • 2013೥8݄: Perlೖֶࣜ in౦ژ • ʮ഑ྻ/ϋογϡ/ϦϑΝϨϯεʯߨ࠲ʹࢀՃ • 2013೥9݄: YAPC::Asia Tokyo 2013 • Perlೖֶࣜ@YAPCʹग़੮͢ΔͨΊॳࢀՃ 6

Slide 7

Slide 7 text

ຊ೔ͷझࢫ

Slide 8

Slide 8 text

झࢫ 1. ϓϩάϥϛϯάͷٕज़ʹ͸ϊϯϓϩά ϥϚʔͷ໾ʹཱͭ΋ͷ͕ͨ͘͞Μ͋Δ 2. ᷿ͷٕज़৘ใͷେ൒͸ϓϩάϥϚʔൃ 3. ϊϯϓϩάϥϚʔʹΑΔϊϯϓϩάϥ ϚʔͷͨΊͷٕज़৘ใΛ۩ମతͳࣄྫ ͱͱ΋ʹ͓ಧ͚͠·͢ʂ 8

Slide 9

Slide 9 text

׆༻ࣄྫ 1. Vim 2. Shell 3. Perl 4. Excel 9

Slide 10

Slide 10 text

Vim

Slide 11

Slide 11 text

Vim 1. IDE෩؀ڥ 2. diffػೳ 11

Slide 12

Slide 12 text

Vim • IDE෩؀ڥ 1. ը໘෼ׂ 2. Plugins 1. vimfiler 2. tagbar 3. easymotion • DEMO 12

Slide 13

Slide 13 text

Vim ࢀߟࢿྉ: • Software Design
 2015೥1݄߸ • ࣮༻Tipsˍରࡦ
 ʦϓϩάϥϚฤʧ
 by @mattn 13

Slide 14

Slide 14 text

Vim • diff/ࠩ෼ػೳ 1. ը໘Λ෼ׂ 2. ର৅σʔλΛ഑ஔ 3. :windo diffthis • DEMO 14

Slide 15

Slide 15 text

Vim • ເͷΑ͏ͳฤूˍࣥච؀ڥ!! • ͳͥϓϩάϥϚʔ͚͕ͩ࢖ͬͯΔͷ͔ʁ • Atom, ͦͷଞIDEͰ΋͍͍͔΋ 15

Slide 16

Slide 16 text

Shell

Slide 17

Slide 17 text

Shell • Perlͱ.bashrcΛ૊Έ߹Θͤͯ 1. σΟϨΫτϦҠಈ 2. ϑΝΠϧݕࡧ 3. จࣈྻݕࡧ • DEMO 17

Slide 18

Slide 18 text

Shell • .bashrc͔ΒPerlεΫϦϓτΛݺͼग़͠ • γΣϧεΫϦϓτͰॻ͘ͷ͕ͭΒ͔ͬͨ • PerlͰॻ͍ͨΒ͙͢ग़དྷͨ 18

Slide 19

Slide 19 text

Shell • Finder͡Όμϝͳͷʁ ➔ ർΕΔ • ੩తUIʹࣗ෼ͷࢹઢΛಈ͔͢ʢಡॻతʣ • λʔϛφϧૢ࡞͸ϥΫ • ಈతUIʹࣗ෼ͷࢹઢ͸ݻఆʢTV/ωοτతʣ • ϗʔϜϙδγϣϯ΋ҡ࣋Ͱ͖Δ 19

Slide 20

Slide 20 text

Perl

Slide 21

Slide 21 text

Perl • ςΩετม׵ثͱͯ͠ར༻ 1. __DATA__ ҎԼʹૉࡐσʔλΛೖΕΔ 2. forจͰ্͔ΒԼ΁Ұؾʹྲྀ͢ 3. ifจͱਖ਼نදݱͰཉ͍͠৘ใΛநग़ 21

Slide 22

Slide 22 text

Perl • ೥දσʔλΛҰׅม׵ 1. ม׵લσʔλʢอ؅༻ʣ 2. ม׵ޙσʔλʢຊ൪σβΠϯ༻ʣ 22

Slide 23

Slide 23 text

Perl • ೥දσʔλΛҰׅม׵ • DEMO 23

Slide 24

Slide 24 text

Perl • ͦͷଞͷࣗ࡞πʔϧ 1. ஫ऍϚʔΫ(*)Λ෇͚ͨ୯ޠΛநग़ • Mecab, Text::ShirasuΛ࢖༻ 2. େྔͷՕ৚ॻ͖͔ΒॏෳߦΛ(நग़|࡟আ) 3. ϑΝΠϧ໊ͷҰ෦Λมߋͯ͠(ίϐʔ|ϦωʔϜ) 24

Slide 25

Slide 25 text

Excel

Slide 26

Slide 26 text

Excel • ࡞ۀه࿥γʔτͷߋ৽ • DEMO 26

Slide 27

Slide 27 text

Excel • ࣌ࠁΛͻͱͭଧͪࠐΊ͹
 ͋ͱ͸Excel͕શ෦ຒΊͯ͘ΕΔ 1. লྗԽɾ࣌ؒઅ໿ 2. σʔλͷਫ਼౓্͕͕Δ 27

Slide 28

Slide 28 text

Excel • Ԡ༻ฤ 28 ೖߘ·Ͱͷ೔਺
 (49೔) ࠓճͷೖߘ49೔લͷ࡞ۀ࣌ؒ(8.55h) લճͷೖߘ49೔લͷ࡞ۀ࣌ؒ(2.40h) ࠩ෼=ࠓճ-લճ ໨ඪ࡞ۀ࣌ؒ(ඪ४/࣮ࡍ)

Slide 29

Slide 29 text

;ΓฦΓ

Slide 30

Slide 30 text

;ΓฦΓ • Α͘Α͘ߟ͑Δͱ… • ϓϩάϥϛϯάΛ࢓ࣄʹ׆͔ͦ͏ͱࢥͬ ͨ͜ͱ͸ͳ͍ • ͍Ζ͍Ζศརʹͳ͔ͬͯΒʮࠓ·Ͱෆ ศͩͬͨ…ʯͱؾͮ͘ 30

Slide 31

Slide 31 text

;ΓฦΓ • ΋ͱ͸ͱݴ͑͹… • ʮϓϩάϥϛϯάͰ͖ͨΒΧοίΠΠ ͳʙʯͱࢥ͍͚ͬͯͨͩ • ೔ৗతʹϓϩάϥϛϯά͢ΔͨΊʹ
 ڧҾʹ࢓ࣄʹऔΓࠐΜͩ 31

Slide 32

Slide 32 text

·ͱΊ ϊϯϓϩάϥϚʔͷϓϩάϥϛϯά׆༻ྫ 1. ୯७࡞ۀ͕ݮͬͨ 
 ➔ PerlͰ೥ද࡞੒, ExcelͰ࡞ۀϩά 2. ࣗ෼ઐ༻ͷ࢓ࣄಓ۩Λ࡞Εͨ 
 ➔ VimͰIDE, diff
 ➔ Shell&PerlͰσΟϨΫτϦҠಈetc. 3. ָ͠Έ͕૿͑ͨ 32