LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 11
Default Find date in excel string previous to last occurence of specific text

I have been combing through multiple forums and excel formula code but cannot find anything to help me out.

I have thousands of strings I need to parse through to extract out a specific date. The date location has no specific parameters around it to easily extract it out. The location from the beginning or the end varies with every string. The only thing that is consistent is a message that reads "Changed Status to Subtasks Created" which can be displayed anywhere from 20 characters to 660 characters after the date we need to extract.

Here is a snippet:
Changed Item Details to CTS Details:
02/15/2013 9:49 AM Escalated Changed Details_1 to CTS Details:
02/15/2013 9:49 AM Escalated Changed Details_2 to
Changed Details_3 to
Added the following Subtasks to this Request: 146448.
Escalated: Rename Master Ticket - NH
Deleted Assignee: UAM
Changed Status to Subtasks Created from Generating Subtasks
Changed Request Title
Changed Initial Approval to None
Changed Additional Approval to No
Changed Ticket Item to
02/15/2013 12:14 PM Escalated Changed Status to Closed from Subtasks Created

So I need to extract then 02/15/2013 9:49 AM text out of this string. The above snippet has 4200 characters in front of what I showed above. Can anyone help?
 
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
How do I find last occurence of a character in a text string in Ex jten Excel Programming 4 August 24th 09 04:02 PM
How to find the first occurence of any number in a string Caio Milani Excel Programming 2 November 7th 06 08:02 PM
Find first occurence of specific data in a column. Ben Excel Programming 3 May 24th 05 03:53 PM
Find specific text in a string Samuel[_5_] Excel Programming 4 February 22nd 05 10:27 PM
Find specific text in a string Kilcup Excel Programming 5 June 10th 04 04:29 PM


All times are GMT +1. The time now is 03:36 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"