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

udzura id:udzura

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

${{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ãƒ†ã‚ã‚¹ãƒˆã‚’Markdownå½¢å¼ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¤‰æ›ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ã¤ãã£ãŸ
Markdownå½¢å¼ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨˜æ³•ã‚’ã„ã¤ã¾ã§ãŸã£ã¦ã‚‚ã†ã‚è¦šãˆã§ã€æ¯Žå›žæ¤œç´¢ã—ãŸã‚Šã€å¤‰æ›ã‚µã‚¤ãƒˆã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã®ãŒé¢å€’ã ã£ãŸã®ã§ãƒ„ãƒ¼ãƒ«ã‚’ã¤ãã‚Šã¾ã—ãŸã€‚å˜˜ã§ã™ã€‚Goæ›¸ããŸã‹ã£ãŸã ã‘ã§ã™ã€‚ ä½¿ã„æ–¹ CSVãƒ†ã‚ã‚¹ãƒˆã‚’æ¨™æº–å…¥åŠ›ã‹ã‚‰å—ã‘å–ã£ã¦æ•´å½¢æ¸ˆã¿ã®Markdownå½¢å¼ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‡ºåŠ›ã—ã¾ã™ã€‚ $ mdt < hoge.csv | headerA | headerB | | ------- | ---------------------- | | short | very very long content | é€£æº ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ãªã®ã§ã€pbpasteã‚„Automatorã¨çµ„ã¿åˆã‚ã›ã¦å¥½ããªã‚ˆã†ã«ä½¿ãˆã¾ã™ã€‚ ä»¥ä¸‹ã¯ã€Automatorã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ç™»éŒ²ã—ãŸmdtã‚’GitHubã®Issueä½œæˆæ™‚ã«å‘¼ã³å‡ºã—ã¦ã„ã‚‹æ§˜åã§ã™ã€‚ ä¾¿åˆ©ã£ã½ã„ã€‚ æ©Ÿèƒ½ CSV/TSVã«å¯¾å¿œ ã‚¿ãƒ–åŒºåˆ‡ã‚Šã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã®ã§ã‚¨ã‚¯
udzura 2015/05/18
ãªã‚‹ã»ã©Automatorã¨çµ„ã¿åˆã‚ã›ã‚‹ã®ã‹ã€ä¾¿åˆ©ã£ã½ã„

csv

markdown
ãƒªãƒ³ã‚¯
æ™®é€šã®CSVã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä½œã‚ŠãŸã„(æ”¹)
class Admin::UsersController < ApplicationController! def index! end! ! def upload! f = params[:data_file]! flash[:notice] = 'Upload successful'! CSV.open(f.path, 'rb', encoding: 'UTF-8').each do |row|! User.create(! ! ! ! em ail: row[0], ! ! ! ! first_name: row[1], ! ! ! ! last_name: row[2]! ! ! )! end! redirect_to action: :index! end! end Admin:UsersController <div class="container">! <h1>Users</
udzura 2014/08/26
csv

rails

pattern
ãƒªãƒ³ã‚¯
Rubyæ¨™æº–æ·»ä»˜ãƒ©ã‚¤ãƒ–ãƒ©ãƒªcsvã®CSV.tableãƒ¡ã‚½ãƒƒãƒ‰ãŒæœ€å¼·ãªä»¶ã«ã¤ã„ã¦
â”€ã€€å•é¡Œï¼‘ã€€â”€ data.csvãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯ã€ï¼•äººã®ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ï¼ˆAlice, Bob, Jimmy, Kent, Rossï¼‰ãŒäºŒç¨®é¡žã®ã‚²ãƒ¼ãƒ ï¼ˆgameA, gameBï¼‰ã‚’ãƒ—ãƒ¬ã‚¤ã—ãŸçµæžœãŒæ¬¡ã®ã‚ˆã†ãªå½¢ã§æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã€‚å„ã‚²ãƒ¼ãƒ ã®å¹³å‡ç‚¹ã‚’æ±‚ã‚ã‚ˆã€‚ data.csv player,gameA,gameB Alice,84.0,79.5 Bob,20.0,56.5 Jimmy,80.0,31.0 Kent,90.5,15.5 Ross,68.0,33.0 data = File.read('data.csv') headers, *scores = data.lines.map { |line| line.chomp.split(',') } scores # => [["Alice", "84.0", "79.5"], ["Bob", "20.0", "56.5"], ["Jimmy", "80
udzura 2013/01/25
csv

ruby
ãƒªãƒ³ã‚¯
è½ã¡ã¶ã‚Œãƒ—ãƒã‚°ãƒ©ãƒžã®æˆ¯è¨€ Â» RFC4180 CSVæ¨™æº–
CSVã£ã¦RFC4180ã¨ã‹ã„ã†ã®ã§æ¨™æº–ãŒã§ãã¦ãŸã®ãã€‚åˆã‚ã¦çŸ¥ã£ãŸã€‚ ã—ã‹ã—ã€2005å¹´åˆ¶å®šã£ã¦ã€ãšã„ã¶ã‚“é…ã„ãª... åºæ–‡ã«ã‚‚ã€ã€Œé©šãã¹ãã“ã¨ã«ã€ã“ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¯ã“ã‚“ãªã«æœ‰åãªã®ã«é–¢ã‚ã‚‰ãšã€ä»Šã¾ã§æ£å¼ãªæ–‡ç« åŒ–ãŒã•ã‚Œã¦ã“ãªã‹ã£ãŸã€ã¨ã‹æ›¸ã„ã¦ã‚ã‚‹ã€‚ RFC4180ã§æ¨™æº–åŒ–ã•ã‚ŒãŸãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®è¦ç‚¹ã¯ãŸã¶ã‚“ä»¥ä¸‹ã®é€šã‚Šã€‚ ï¼‘è¡Œã«ï¼‘ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãã€è¡Œã¯CRLFã§åŒºåˆ‡ã‚‹ æœ€çµ‚è¡Œã®CRLFã¯ã‚ã£ã¦ã‚‚ç„¡ãã¦ã‚‚ã„ã„ ï¼‘è¡Œç›®ã¯ãƒ˜ãƒƒãƒ€è¡Œã§ã‚‚è‰¯ã„ã€‚ãƒ˜ãƒƒãƒ€è¡Œã®é …ç›®æ•°ã¨ãƒ‡ãƒ¼ã‚¿è¡Œã®é …ç›®æ•°ã¯ä¸€è‡´ã™ã‚‹ã“ã¨ï¼ˆå°šã€ãƒ˜ãƒƒãƒ€ãŒã‚ã‚‹ã‹ã©ã†ã‹ã¯MIMEã‚¿ã‚¤ãƒ—ã«ã€Œheaderã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä»˜ã‘ã‚‹ã“ã¨ã§æ˜Žç¤ºã™ã‚‹ã¹ãã€‚ï¼‰ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã¯ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã‚‹ã€‚å…¨ã¦ã®è¡Œã¯åŒã˜æ•°ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’æŒã¤ã¹ãã€‚ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ä¸ã®ã‚¹ãƒšãƒ¼ã‚¹ã¯ç„¡è¦–ã™ã‚‹ã¹ãã§ã¯ãªã„ã€‚æœ€çµ‚ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®å¾Œã‚ã«ä½™è¨ˆãªã‚«ãƒ³ãƒžã¯ä»˜ã‘ã‚‹ãªã€‚ å„ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã¯ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã§æ‹¬ã£ã¦ã‚‚è‰¯ã„ã€‚ãƒ€ãƒ–
udzura 2011/06/14
[for:@twitter]

csv

rfc
ãƒªãƒ³ã‚¯
FasterCSVã«ã‚ˆã‚‹CSVãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µãƒ³ãƒ—ãƒ«ï¼‘ - ã‚ãã§ãªã—ç„¡è·ã®å‹‰å¼·æ—¥è¨˜
æ–°ç±³ã¨ç§‹åˆ€éšã®ã‚ãŸç„¼ã ãŠåˆºèº«ç”¨ã®ç§‹åˆ€éšã‚’è²·ã„ã¾ã—ãŸã€‚1å°¾250å††ã§ã™ 3æžšã«ãŠã‚ã—ã¦ã€ç§‹åˆ€éšã®ã‚ãŸã«é…’ã€å‘³é†‚ã€é†¤æ²¹ã§èª¿å‘³ã—ã¦1æ™‚é–“ã»ã©æ¼¬ã‘è¾¼ã¿ã€ã‚°ãƒªãƒ«ã§ç„¼ãã¾ã—ãŸ ç§‹åˆ€éšã®ã‚ãŸç„¼ã ã‚ãŸã®ã€è‹¦å‘³ãŒç¨‹ã‚ˆããƒžã‚¤ãƒ«ãƒ‰ã«èª¿å‘³ã•ã‚Œã€ã‚¯ã‚»ã«ãªã‚‹å‘³ã‚ã„ã§ã™ è‰¶ã‚„ã‹ãªæ–°ç±³ã¨ä¸€ç·’ã« è‡ªå®¶è£½ãŠæ¼¬ç‰© åœŸâ€¦
udzura 2009/11/10
send_dataã—ãŸã„

ruby

csv
ãƒªãƒ³ã‚¯
FasterCSVã§ãƒ‘ãƒ¼ã‚¹:ãŠé¡Œç›®ã†ã‰ã£ã¡
2008å¹´04æœˆ15æ—¥ FasterCSVã§ãƒ‘ãƒ¼ã‚¹ å··ã§é…ã„é…ã„ã¨è©•åˆ¤ã®ã€æ¨™æº–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ã¤ã„ã¦ã„ã‚‹CSVãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã€‚æœ¬æ—¥ãŸã¾ãŸã¾CSVã‚’åŠ å·¥ã™ã‚‹ç”¨é€”ãŒã‚ã£ãŸã®ã§ã€åå‰ã‹ã‚‰ã—ã¦æ—©ãã†ãªã€ŒfasterCSVã€ã‚’ä½¿ã£ã¦ã¿ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ gem ã§ä¸€ç™ºã€‚ require 'fastercsv' ... outfile = FasterCSV.open(ARGV.shift, "w", {:force_quotes => true}) FasterCSV.foreach(ARGV.shift) do |row| if $. > 1 row[6] = @appendStr + row[6].to_s unless /#{@appedstr}/ =~ row[6] else row[6] = row[6].gsub(@appendStr, '') end end outfile << row e
udzura 2009/03/11
ruby

csv
ãƒªãƒ³ã‚¯
1