Decoding a csv string into a readable xls

A

ah

Having trouble syncing my PPC Calendar with Outlook and wanting to save my
appointments, I used PIMBackup to create an excel sheet. I can now see all
my appointments and I’d like to organise them by date and time but I am
having trouble with the associated code. I copy below for example one of
yesterday’s (23 Apr 09) appointment that reads on my PPC calendar as:

S 5071 london nice 18:30-21:30

This is the associated line:

S 5071 london
nice;"0x00,0x00";"";;"0x02,0x00,0x00,0x00";"";"0xb4,0x00,0x00,0x00";"0xab,0xaa,0xaa,0xaa,0xdc,0x7e,0xe3,0x40";"0x00,0x00";"";"0x00,0x00,0x00,0x00";"0x0f,0x00,0x00,0x00";"0x04,0x00,0x00,0x00";"0x00,0x00";"";"0x00,0x00,0x00,0x00";"0xab,0xaa,0xaa,0xaa,0xd8,0x7e,0xe3,0x40";"0x00,0x00,0x00,0x00";"0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0xb4,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0xab,0xaa,0xaa,0xaa,0xaa,0xaa,0xec,0x3f,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0xff,0xff,0x00,0x00,0xff,0xff,0xff,0xff,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0xdc,0xfd,0x2c,0x41,0x00,0x00,0x00,0x00,0xc0,0x7e,0xe3,0x40,0xff,0xff,0xff,0xff,0x00,0x00,0x00,0x00,0xab,0xaa,0xaa,0xaa,0xaa,0xaa,0xe8,0x3f,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00";

I would like to transform it back into:

S 5071 london nice 18:30-21:30

Thank you in advance for any help.
 
Top