iWork

suite, which is (for the moment) very smooth and polished but not quite up to scratch when it comes to professional use.

It currently consists of:

  • its star app
  • Pages, a simple word processor
  • Numbers, a simple spreadsheet

h2. Stupid Tricks

h3. Pasting Data Into Multiple Columns

Numbers will paste textual clipboard data into separate columns if it contains tabs, so you can easily paste in CSV data by tweaking the clipboard using something like:

pbpaste | sed “s/;/\t/g” | pbcopy

Since Mac OS X’s is BSD-based, you will need to replace the @\t@ by a literal tab character - type @Ctrl+V@ and then hit @Tab@ to insert that instead.

This page is referenced in: