• awk

    2 min read · system csv

    Basics See a file's contents: Return full contents of a string: 1awk '{ print }' file Print the first and second column: 1awk '{print$1$2}' Return every line with the word 'the' (like grep): 1awk '/the/{print}' file Print everything containing a lowercase letter: 1awk '/[a-z]/{print}' file Same with numbers [0-9], or …


    Read More

  • CSV to Markdown in Vim

    3 min read · writing vim csv markdown

    Requirements vim basics Open a CSV table (I made this one with :r!sed 's/:/,/g' /etc/passwd | head). 1root,x,0,0,,/root,/bin/bash 2bin,x,1,1,,/,/usr/bin/nologin 3daemon,x,2,2,,/,/usr/bin/nologin 4mail,x,8,12,,/var/spool/mail,/usr/bin/nologin 5ftp,x,14,11,,/srv/ftp,/usr/bin/nologin …


    Read More

  • Format a CSV file as markdown in vim

    1 min read · vim markdown csv

    The command to format CSV tables works similarly to formatting markdown. Put this in your ~/.vimrc and use Control + s after highlighting a cs 1vmap <C-s> :!column -ts, -o " | "<Enter>yyp:s/[^|:]/-/g<Enter> Read a CSV file into Vim: 1r ${file}.csv Select the csv output: 1Transaction Date,Transaction Type,Transaction …


    Read More

  • mlr

    1 min read · csv markdown data mlr

    Convert markdown table to csv 1mlr --imarkdown --ocsv cat ${file}.md Convert a csv file to markdown 1mlr --icsv --omd cat ${file}.csv


    Read More

  • sc-im

    1 min read · TUI data spreadsheet csv

    Requirements vim basics Basic Commands See Cells Cells are hard to see. Change this with :set autowrap. Make sc-im always autowrap: 1mkdir .config/sc-im/bash 2echo 'set autowrap' >> .config/sc-im/scimrc Movement Command Key highest part H lowest part L top gg most right. g$ most left. g0 insert middle \ insert left > …


    Read More