robbclaxton
IS-IT--Management
I would like to search a string for a keyword or phrase and subsequently strip the keyword and the proceeding characters from the string.
for example
Tank/Sensor-number: 04 - Questionable Deiveries:
01/02/2011 02:00:00 - Ticketed=14400.0 - Measured=11655.0
Find 'Ticketed=' and return 'Ticketed=14400.0'
Find 'Measured=' and return 'Measured=11655.0'
Equally I would like to strip the date record but due to the spaces I wondered whether I could find the start and end of the date.
Any help would be really appreciated.
for example
Tank/Sensor-number: 04 - Questionable Deiveries:
01/02/2011 02:00:00 - Ticketed=14400.0 - Measured=11655.0
Find 'Ticketed=' and return 'Ticketed=14400.0'
Find 'Measured=' and return 'Measured=11655.0'
Equally I would like to strip the date record but due to the spaces I wondered whether I could find the start and end of the date.
Any help would be really appreciated.