Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decoding an old macro | Excel Discussion (Misc queries) | |||
how can I open a file if its needs decoding with BINHEX4 | Excel Discussion (Misc queries) | |||
Decoding a Range String | Excel Programming | |||
A question about decoding, substitute or vlookup of character. | Excel Programming | |||
Decoding Part number entries for all values embedded | Excel Programming |