Decoding a csv string into a readable xls
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 Id like to organise them by date and time but I am having trouble with the associated code. I copy below for example one of yesterdays (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";"";"0xb 4,0x00,0x00,0x00";"0xab,0xaa,0xaa,0xaa,0xdc,0x7e,0 xe3,0x40";"0x00,0x00";"";"0x00,0x00,0x00,0x00";"0x 0f,0x00,0x00,0x00";"0x04,0x00,0x00,0x00";"0x00,0x0 0";"";"0x00,0x00,0x00,0x00";"0xab,0xaa,0xaa,0xaa,0 xd8,0x7e,0xe3,0x40";"0x00,0x00,0x00,0x00";"0x00,0x 00,0x00,0x00,0x00,0x00,0x00,0x00,0xb4,0x00,0x00,0x 00,0x00,0x00,0x00,0x00,0xab,0xaa,0xaa,0xaa,0xaa,0x aa,0xec,0x3f,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x 00,0x00,0x00,0x00,0x00,0xff,0xff,0x00,0x00,0xff,0x ff,0xff,0xff,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x 00,0xdc,0xfd,0x2c,0x41,0x00,0x00,0x00,0x00,0xc0,0x 7e,0xe3,0x40,0xff,0xff,0xff,0xff,0x00,0x00,0x00,0x 00,0xab,0xaa,0xaa,0xaa,0xaa,0xaa,0xe8,0x3f,0x00,0x 00,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. |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com