Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 126
Default Parse email text

I wonder if anyone could get me started on how to parse the text body
of an email.

The body looks like this:

--------------------|-----------|-----------|-----------|-----------|-----------|-----------|-----------|-------------
|Sunday |Monday |Tuesday |Wednesday |
Thursday |Friday |Saturday |
|03/09/08 |03/10/08 |03/11/08 |03/12/08 |
03/13/08 |03/14/08 |03/15/08 |
--------------------|-----------|-----------|-----------|-----------|-----------|-----------|-----------|-------------
7550 |OFF | 0930-1730| 0900-1700| 0900-1700|
0930-1730| 0930-1730|OFF |
Joe, Hammer |L 1400-1500|T 0900-1300|T 0900-1300|L 1400-1500|
L
1400-1500| |
| | |L 1300-1400|L
1300-1400| | | |
| | |T 1400-1700|T
1400-1700| | | |
--------------------|-----------|-----------|-----------|-----------|-----------|-----------|-----------|-------------

The email contains a list of schedules for several people.
basically it is just a text file.
The first 'column' is dependent on the longest name of all the
individuals, the weekly 'columns' are static in size but as you can
see they can have several 'rows'.
These events are triggered by a letter code in front of the hour.
I need to parse each person and find any special events and copy them
into rows.

In my example I need to look for all the times
that have a 'T', for ie Tuesday 0900-1300 and 1400-1700.

I have been playing with this for awhile and all I come up is a messy
spaghetti code and I not getting anywhere.
My difficulty is that the info is not located in the same place but it
is dynamic, so I need to find a way to find in the text.
I would appreciate any help that would get me started on this.
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 360
Default Parse email text

You may have better luck posting in a Word group, or Lotus Notes or
Outlook.

Cliff Edwards
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 126
Default Parse email text

On Mar 10, 1:05*am, ward376 wrote:
You may have better luck posting in a Word group, or Lotus Notes or
Outlook.

Cliff Edwards


I will try.
Thanks
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
parse name from email address [email protected] Excel Discussion (Misc queries) 2 May 21st 07 03:28 PM
parse email address Michael Connolly Excel Discussion (Misc queries) 4 November 7th 06 12:09 PM
Parse an email address Michael Connolly Excel Worksheet Functions 2 November 3rd 06 04:02 PM
Parse an email address Michael Connolly Excel Worksheet Functions 1 November 3rd 06 03:53 PM
How do I get this data from email (Parse) Steve[_73_] Excel Programming 5 January 31st 06 02:39 AM


All times are GMT +1. The time now is 09:03 AM.

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

About Us

"It's about Microsoft Excel"