ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Decoding a csv string into a readable xls (https://www.excelbanter.com/excel-programming/427452-decoding-csv-string-into-readable-xls.html)

ah

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