PDA

View Full Version : To extract characters appearing right side of a particular string


Chandrakanth09
Jan 29, 2011, 04:21 AM
Mysql or excel function to extract characters after the occurrence of a particular string

For example: Suppose

"http://10.20.30.40:8080/aptv-web/PROGRAMS/TIMESNOW/LIVE/64BIT/TIMESNOWLive_03 "

This is the statement through which I need to extract the characters appearing right side of "/64BIT/"

The result should be TIMESNOWLive_03

JBeaucaire
Jan 29, 2011, 07:44 AM
Try this:

=MID(A1, FIND("/64BIT/", A1)+7, LEN(A1))

Chandrakanth09
Jan 29, 2011, 06:02 PM
Thanks Sir...
It's working..