Appleworks 6.2 sucks: Unable to import a simple CVS file?

I decided to buy Appleworks when I got my Apple Quad machine as OpenOffice support seemed to be weak on OSX and I was not going to give $500+ dollars to Microsoft to use a 2004 version of Office.

So I was somehow happy with Appleworks until I decided to do something simple as to import a CSV file created with Google Finance portfolio application.

It didn't work. Fustrated I asked for help on the Apple support forum (the Appleworks FAQ is just useless at least with this particular issue) and luckly for me I got my answer in a couple of hours.

At the end I rolled out a savy one Perl liner that solved my problem:

auyan:~/Desktop josevnz$ perl -p -i -e 's#,#\t#g; s#\n#\rn#;' 401k-funds-appleworks.csv

I guess I will try OpenOffice again or will buy Office for OSX and byte the bullet. But my advice is to stay away from a product that cannot deal with a simple conversions like this :(

Correction: Is CSV file not CVS. Too lazy to republish the whole thing again :)

Blogalaxia:appleworks, sucks, import csv, open office, microsoft office, perl
Technorati:appleworks, sucks, import csv, open office, microsoft office, perl
To2blogs:appleworks, sucks, import csv, open office, microsoft office, perl
Del.icio.us:appleworks, sucks, import csv, open office, microsoft office, perl