q - Text as Data
q - Run SQL directly on CSV or TSV files¶ Overview¶ q's purpose is to bring SQL expressive power to the Linux command line by providing easy access to text as actual data, and allowing direct access to multi-file sqlite3 databases. q <flags> <sql-query> q allows the following: Performing SQL-like statements directly on tabular text data, auto-caching the data in order to accelerate additional quer
CSVテã‚ストをMarkdownå½¢å¼ã®ãƒ†ãƒ¼ãƒ–ルã«å¤‰æ›ã™ã‚‹ãƒ„ールをã¤ãã£ãŸ
Markdownå½¢å¼ã®ãƒ†ãƒ¼ãƒ–ル記法をã„ã¤ã¾ã§ãŸã£ã¦ã‚‚ã†ã‚覚ãˆã§ã€æ¯Žå›žæ¤œç´¢ã—ãŸã‚Šã€å¤‰æ›ã‚µã‚¤ãƒˆã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã®ãŒé¢å€’ã ã£ãŸã®ã§ãƒ„ールをã¤ãã‚Šã¾ã—ãŸã€‚嘘ã§ã™ã€‚Go書ããŸã‹ã£ãŸã ã‘ã§ã™ã€‚ 使ã„æ–¹ CSVテã‚ストを標準入力ã‹ã‚‰å—ã‘å–ã£ã¦æ•´å½¢æ¸ˆã¿ã®Markdownå½¢å¼ãƒ†ãƒ¼ãƒ–ルを出力ã—ã¾ã™ã€‚ $ mdt < hoge.csv | headerA | headerB | | ------- | ---------------------- | | short | very very long content | é€£æº ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ãªã®ã§ã€pbpasteã‚„Automatorã¨çµ„ã¿åˆã‚ã›ã¦å¥½ããªã‚ˆã†ã«ä½¿ãˆã¾ã™ã€‚ 以下ã¯ã€Automatorã®ã‚µãƒ¼ãƒ“スã¨ã—ã¦ç™»éŒ²ã—ãŸmdtã‚’GitHubã®Issue作æˆæ™‚ã«å‘¼ã³å‡ºã—ã¦ã„る様åã§ã™ã€‚ 便利ã£ã½ã„。 機能 CSV/TSVã«å¯¾å¿œ タブ区切りã«ã‚‚対応ã—ã¦ã„ã‚‹ã®ã§ã‚¨ã‚¯
instaparseã§CSVパーサーを書ã„ã¦ã¿ã‚‹ - Code Aquarium
instaparseã¯æ–‡è„ˆè‡ªç”±æ–‡æ³•(CFG)ã«ã‚ˆã‚‹æ§‹æ–‡è§£æžãƒ©ã‚¤ãƒ–ラリã§ã™ã€‚ã»ã¼ãã®ã¾ã¾ã®EBNFã¨æ£è¦è¡¨ç¾ã‚’使ãˆã¾ã™ã€‚ã“ã“ã§ã¯æ‰‹ã”ã‚ãªã¨ã“ã‚ã§CSVã®è§£æžå™¨ã‚’作ã£ã¦ã¿ã¾ã™ã€‚ leiningenプãƒã‚¸ã‚§ã‚¯ãƒˆä¾å˜ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« 何ã¯ã¨ã‚‚ã‚ã‚Œproject.clj。最低é™å¿…è¦ãªãƒ©ã‚¤ãƒ–ラリã¯ä»¥ä¸‹ã®äºŒã¤ã€‚ :dependencies [[org.clojure/clojure "1.5.1"] [instaparse "1.0.1"]] CSVã®BNF CSVã¯RFC4180ã«BNFãŒè¨˜è¿°ã•ã‚Œã¦ã„ã‚‹ã®ã§ã“れをæ‹å€Ÿã—ã¾ã™ã€‚ file = [header CRLF] record *(CRLF record) [CRLF] header = name *(COMMA name) record = field *(COMMA field) name = field field = (escaped / non
CSVデータをデータベース化ã™ã‚‹ãƒ„ール「CtoDã€ã®ç´¹ä»‹
å‰ã®è¨˜äº‹ã§ã¯CtoDを使ã£ã¦CSVデータã‹ã‚‰Heroku上ã«Webアプリを構築ã™ã‚‹æ‰‹é †ã‚’説明ã—ã¾ã—ãŸã€‚ Excelデータを最速ã§Webアプリ(Heroku)ã«ã™ã‚‹ï¼‘ï¼ï¼™ã®ã‚¹ãƒ†ãƒƒãƒ— ã“ã“ã§ã¯CtoDã®è©³ç´°ã‚’説明ã—ã¾ã™ã€‚対象ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯0.0.3ã§ã™ã€‚ ctoD | RubyGems.org | your community gem host melborne/ctoD 使ã„æ–¹ gem install ctoDã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€ctoDターミナルコマンドãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚サブコマンドを渡ã•ãªã‘ã‚Œã°ãã®ãƒ˜ãƒ«ãƒ—ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ % ctoD Commands: ctoD create_table CSV DATABASE # Create a database table for CSV ctoD export CSV DATABASE # Export CSV data to DATA
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}