iWork

Office 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

Stupid Tricks

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: