Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I find last occurence of a character in a text string in Ex | Excel Programming | |||
How to find the first occurence of any number in a string | Excel Programming | |||
Find first occurence of specific data in a column. | Excel Programming | |||
Find specific text in a string | Excel Programming | |||
Find specific text in a string | Excel Programming |