Skip to content

myhacks: align, excel2csv,

file under *tocode
will prolly take just as much time to write as it will to scope out.

  • simple script to align the columns in a multi-column file:
    it’ll take in a file of tab-sep or multi-space sep columns, read it all in, and have the length of the space between columns be the length of the longest item in the preceding column + 4 spaces. just to line stuff up nicely.
  • can also write another app to do the reverse of this: take these columns, and produce a tsv or csv file from them for easy excel import.
  • write an script to convert excel format to csv (there’s gotta be something like this)
    update: 2005/01/28: this excel2csv.pl script does the trick, courtesy of http://www.wlug.org.nz/Excel2CSV
  • and then there’s the ever-needed “todo”-organizing program