[B! csv] fragarach_the_swordã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

fragarach_the_sword id:fragarach_the_sword

csvã«é–¢ã™ã‚‹fragarach_the_swordã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’2æ¬¡å…ƒé…åˆ—ã«èªã¿è¾¼ã‚€perlã‚µãƒ³ãƒ—ãƒ«
Linuxé–¢é€£ã®æ‰‹é †ãƒ¡ãƒ¢å ´æ‰€ã ã£ãŸã‚Šã—ã¾ã™ã€‚ (Almost private technical memo about Linux.) è‡ªå‹•è²©å£²æ©Ÿã®åœ¨åº«ç®¡ç†ã‚’ä¾‹ã¨ã—ã¦CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’2æ¬¡å…ƒé…åˆ—ã«èªã¿è¾¼ã‚€perlã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚ ã¾ãšã¯è¡Œã”ã¨ã«1æ¬¡å…ƒé…åˆ—(@csv_array)ã«èªã¿è¾¼ã¿ã€å„è¡Œã®è¦ç´ ã¯ä¸€åº¦(@line)é…åˆ—ã«ä¿æŒã—ã€ splité–¢æ•°ã‚’ä½¿ç”¨ã—ã¦2æ¬¡å…ƒé…åˆ—(@line_data)ã«èªã¿è¾¼ã‚“ã§ã„ã¾ã™ã€‚ é…åˆ—ã«èªã¿è¾¼ã‚“ã å¾Œã®å‡¦ç†ã¯é©å½“ã§ã™ã€‚ é…åˆ—ã‚’CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹æº–å‚™ã¨ã—ã¦2æ¬¡å…ƒé…åˆ—(@line_data)ã‚’joiné–¢æ•°ã‚’ä½¿ç”¨ã—ã¦ ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã®è¦ç´ ã¨ã—ãŸ1æ¬¡å…ƒé…åˆ—(@line_consolidate)ã«æ•´å½¢ã—ãŸå¾Œã« CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã—ã¦ã„ã¾ã™ã€‚ â– æ§‹æˆæƒ…å ± ãƒ»OS: Amazon Linux AMI release 2012.09(64bit) ãƒ»Perl: 5.10.1
fragarach_the_sword 2018/04/16
ã‚Šãªã£ãã™ãªã†ã€‚: CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’2æ¬¡å…ƒé…åˆ—ã«èªã¿è¾¼ã‚€perlã‚µãƒ³ãƒ—ãƒ«

perl

coding

program

software

develop

tips

sample

linux

csv
ãƒªãƒ³ã‚¯
Perlã«ã‚ˆã‚‹CSVãƒ•ã‚¡ã‚¤ãƒ«ã®é«˜é€Ÿé›†è¨ˆ 2
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
fragarach_the_sword 2018/04/15
Perlã«ã‚ˆã‚‹CSVãƒ•ã‚¡ã‚¤ãƒ«ã®é«˜é€Ÿé›†è¨ˆ 2 (1/2)ï¼šCodeZine

perl

coding

program

software

develop

tips

tutorial

csv

join

hashtable
ãƒªãƒ³ã‚¯
perlã§CSVãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿ã€‚
æ¦‚è¦CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã¿ã€ãã‚Œã‚’é…åˆ—ã®ãƒãƒƒã‚·ãƒ¥ã«ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ç°¡å˜ã«ã¾ã¨ã‚ã¾ã™ã€‚ ã‚ˆã¿ã“ã‚€ãƒ•ã‚¡ã‚¤ãƒ«ä½æ‰€éŒ²ã‚„åç°¿ã¦ããªã‚‚ã®ã§ã¯ãªãã€ã‚ãƒ¼ã«ã‚ˆã£ã¦ã¯è¦ç´ æ•°ãŒå¤‰ã‚ã‚‹ã‚ˆã†ãªã‚‚ã®ã‚’æƒ³å®šã—ã¦ã¾ã™ã€‚ ãƒ™ã‚¢ãƒ¼ã‚º,å±±ç”°ã€éˆ´æœ¨ã€ä½è—¤ã€ ã‚¿ã‚¤ã‚¬ãƒ¼ã‚¹ã€ç”°ä¸ã€ä¸ç”°ã€ä¸å³¶ã€ãƒˆãƒ ãƒ©ã‚¤ã‚ªãƒ³ã‚ºã€ãƒžã‚¤ã‚±ãƒ«ã€ã‚¸ãƒ£ã‚¯ã‚½ãƒ³ã€ãƒˆãƒ¼ãƒžã‚¹ã€ãƒ‡ã‚£ãƒƒã‚¯ ä½æ‰€éŒ²çš„ãªã‚‚ã®ã¯ã“ã¡ã‚‰ã§ã€ http://codezine.jp/article/detail/904?p=1 ã‚³ãƒ¼ãƒ‰my %hash; foreach my $line( @list ) { chomp $line; my ( $key, @it ems ) = split( /,/, $line ); $hash{$key} = [@it ems]; } ãƒã‚¤ãƒ³ãƒˆï¼ˆè‹¦åŠ´ã—ãŸç‚¹ï¼‰ã¯9è¡Œç›®ã¨10è¡Œç›®ã§ã™ã€‚ ã¾ãšã¯ã€my ( $key, @it ems ) = split( /,/, $li
fragarach_the_sword 2018/04/15
è¶£å‘³ã®ãƒ—ãƒã‚°ãƒ©ãƒ : perlã§CSVãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿ã€‚

perl

coding

program

csv

tips

sample
ãƒªãƒ³ã‚¯
zabbixã§CPUä½¿ç”¨çŽ‡ã‚„DISKä½¿ç”¨é‡ ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ãªã©ã®éŽåŽ»ãƒ‡ãƒ¼ã‚¿(ãƒ’ã‚¹ãƒˆãƒª)ã‚’CSVå½¢å¼ã«ã¦ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›ã™ã‚‹æ–¹æ³• - å±±æ¢¨ã‚¹ã‚ºãƒ¡ãƒãƒé§†é™¤ã‚»ãƒ³ã‚¿ãƒ¼ã€€æ¥å‹™ãƒ–ãƒã‚°ã®è¤‡è£½
zabbixã«ã¦éŽåŽ»ã®ã‚°ãƒ©ãƒ•ã®ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹å ´åˆã¯ã€ 1.ã€Œç›£è¦–ãƒ‡ãƒ¼ã‚¿ã€ã‹ã‚‰ã€Œæœ€æ–°ãƒ‡ãƒ¼ã‚¿ã€ã§"æœ€æ–°ã®ãƒ‡ãƒ¼ã‚¿"ã‚’è¡¨ç¤º 2.å³ä¸Šã®ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ã‹ã‚‰ã€Œå€¤ã€ã‚’é¸æŠž 3.æ¨ªã«ã‚ã‚‹ã€Œãƒ—ãƒ¬ãƒ¼ãƒ³ãƒ†ã‚ã‚¹ãƒˆã€ãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ã€‚ 4.çµæžœã‚’ã‚³ãƒ”ãƒ¼ã—ã¦excelã«è²¼ã‚Šä»˜ã‘ ã¨ã„ã£ãŸæ–¹æ³•ã«ã¦å®Ÿæ–½ã§ãã¾ã™ã€‚ ã§ã™ãŒã€ã“ã®æ–¹æ³•ã ã¨1000ä»¶ã¾ã§ã—ã‹è¡¨ç¤ºã§ãã¾ã›ã‚“ã€‚ 1000ä»¶ä»¥ä¸Šã€è¡¨ç¤ºã—ãŸã„å ´åˆã¯ã€ä»¥ä¸‹ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ 1..telnetãªã©ã§ã€zabbixã‚µãƒ¼ãƒã«ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã§ãã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§æŽ¥ç¶šã€‚ 2..CSVãƒ‡ãƒ¼ã‚¿å–å¾—å¯¾è±¡ã®ãƒ›ã‚¹ãƒˆã®ãƒ›ã‚¹ãƒˆï¼©ï¼¤(5ã‚±ã‚¿ã®æ•°å—)ã‚’èª¿æŸ»ã—ã¾ã™ã€‚ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã§èª¿æŸ»ã—ã¾ã™ã€‚ # mysql --user=(zabbixãƒ¦ãƒ¼ã‚¶å) --password=(zabbixãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰) (zabbixãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) -e "select hostid,host from host
fragarach_the_sword 2014/04/15
zabbixã§CPUä½¿ç”¨çŽ‡ã‚„DISKä½¿ç”¨é‡ ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ãªã©ã®éŽåŽ»ãƒ‡ãƒ¼ã‚¿(ãƒ’ã‚¹ãƒˆãƒª)ã‚’CSVå½¢å¼ã«ã¦ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›ã™ã‚‹æ–¹æ³• - å±±æ¢¨ã‚¹ã‚ºãƒ¡ãƒãƒé§†é™¤ã‚»ãƒ³ã‚¿ãƒ¼ã€€æ¥å‹™ãƒ–ãƒã‚°ã®è¤‡è£½

zabbix

maintenance

tool

ç›£è¦–

database

csv

performance

datacenter

tips
ãƒªãƒ³ã‚¯
Stateãƒ‘ã‚¿ãƒ¼ãƒ³ã§CSVã‚’èªã‚€
ã“ã‚“ãªã®ã‚’èªã¿è¾¼ã‚“ã§é©å½“ãªå‡¦ç†ã‚’æ–½ã—ã¦æ¬²ã—ã„ã€ã¨ã€‚Excelã®ã‚·ãƒ¼ãƒˆã‹ã‚‰å„ã‚»ãƒ«ã®å€¤ã‚’æ‹¾ã„å‡ºã™ã®ã¯ã•ã»ã©ã«é›£ã—ãã¯ãªã„ã®ã§ã™ãŒã€ã„ã‹ã‚“ã›ã‚“æ™‚é–“ãŒãªã‹ã£ãŸã®ã§ã„ã£ãŸã‚“ã¯ãŠæ–ã‚Šã—ãŸã¨ã“ã‚ã€ã€ŒExcelã‚·ãƒ¼ãƒˆã‚’ç›´æŽ¥èªã‚€ã®ãŒé¢å€’ãªã‚‰CSVã‹ã‚‰ã§ã‚‚ã‹ã¾ã‚ã‚“ã€ã¨ã®ã“ã¨ã€‚CSVãªã‚‰ãƒ•ãƒ„ãƒ¼ã«ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã‚ã°ã„ã„ã‹ã‚‰å°ä¸€æ™‚é–“ã§ä½œã‚Œãã†ã€æ˜¼ãƒ¡ã‚·å¥¢ã£ã¦ã‚‚ã‚‰ã†ã®ã‚’å ±é…¬ã«å¼•ãå—ã‘ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ CSVã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ CSVï¼ˆComma Separated Valuesï¼‰ã¯MS-DOSã‚ã‚‹ã„ã¯ãã®ä»¥å‰ã‹ã‚‰ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¨ã—ã¦ä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚CSVã®è¦æ ¼/æ¨™æº–ã¨ã—ã¦ã¯RFC4180ãŒã‚ã‚Šã¾ã™ãŒã€ã“ã„ã¤ã¯2005å¹´ã«ä½œã‚‰ã‚ŒãŸã‚‚ã®ã§ãã‚Œä»¥å‰ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒRFC4180ã«æº–æ‹ ã—ã¦ã„ã‚‹ã“ã¨ã¯æœŸå¾…ã§ãã‚‹ã¯ãšã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ã¨ã¯ã„ãˆã€ã¾ãšã¯RFC4180ã«å¾“ã£ã¦ä½œã‚‰ã‚ŒãŸCSVãªã‚‰æ£ã—ãèªã‚ã‚‹ã“
fragarach_the_sword 2010/12/21
CodeZineï¼šStateãƒ‘ã‚¿ãƒ¼ãƒ³ã§CSVã‚’èªã‚€

develop

c++

sample

tutorial

ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³

csv
ãƒªãƒ³ã‚¯
1