Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ah ah is offline
external usenet poster
 
Posts: 33
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decoding an old macro WendiL99 Excel Discussion (Misc queries) 1 June 19th 06 03:44 PM
how can I open a file if its needs decoding with BINHEX4 Glenchass Excel Discussion (Misc queries) 2 May 1st 06 02:15 PM
Decoding a Range String Tom Ogilvy Excel Programming 1 June 8th 04 03:21 AM
A question about decoding, substitute or vlookup of character. Alan Pong Excel Programming 2 October 10th 03 08:24 AM
Decoding Part number entries for all values embedded Otto Moehrbach[_3_] Excel Programming 0 August 4th 03 10:57 PM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"