As mentioned previously, the CSV files produced by Blackberry Messenger 5.0+ need some cleaning up before they can be properly used. I finally wrote a short script for doing just that.
You can download the VBScript here:
bbmcleaner-1.1.zip. This code is released to the public domain.
Once you have the BBM log file on your computer (email it there from your phone, again, see the last post on this subject), just drag and drop it onto this
.vbs file, and a “clean” version will be produced as a separate file in the same directory. The new file will have human-readable dates and the message will be properly escaped–in short, it will be something you can just open and use in Excel (e.g.).
Version 1.1 (Feb 20, 2010)
GMTOffsetconstant to allow timestamps to be properly adjusted for time zones.