Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   To extract characters appearing right side of a particular string (https://www.askmehelpdesk.com/showthread.php?t=548979)

  • Jan 29, 2011, 04:21 AM
    Chandrakanth09
    To extract characters appearing right side of a particular string
    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
  • Jan 29, 2011, 07:44 AM
    JBeaucaire

    Try this:

    =MID(A1, FIND("/64BIT/", A1)+7, LEN(A1))
  • Jan 29, 2011, 06:02 PM
    Chandrakanth09
    Comment on JBeaucaire's post
    Thanks Sir...
    It's working..

  • All times are GMT -7. The time now is 11:15 PM.