Ask Experts Questions for FREE Help !
Ask
    Chandrakanth09's Avatar
    Chandrakanth09 Posts: 5, Reputation: 1
    New Member
    		  
    #1

    Jan 29, 2011, 04:21 AM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jan 29, 2011, 07:44 AM

    Try this:

    =MID(A1, FIND("/64BIT/", A1)+7, LEN(A1))
    Chandrakanth09's Avatar
    Chandrakanth09 Posts: 5, Reputation: 1
    New Member
    		  
    #3

    Jan 29, 2011, 06:02 PM
    Comment on JBeaucaire's post
    Thanks Sir...
    It's working..
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

In a 2 hour movie, How many main characters and other characters should you have? [ 1 Answers ]

I'm making a movie and I have 7 main characters and about 12 enemies/badguys/antagonists. I don't know if this is a good way to do it.. or should I reduce the number of main characters. The movie is animation and I'm not a professional movie maker. Just hobbiest

(Microsoft Excel) - Need to extract a specific number from text string [ 2 Answers ]

For example, cell K1 looks like this Z. Thornton(90), J. Bornstein(90), A. Jazic(65), C. Talley(90), Y. Cuesta(90), S. Kljestan(90), P. Nagamura(90), M. Lahoud(90), J. Braun(90), J. Padilla(46), Maicon Santos(60) I want a formula that will give me the number to the right of a name if the cell...

SQL Expression to extract part of a string divided by dashes [ 4 Answers ]

Hi, I have a field (Tag_Num) in an Access database that contains a heap of values that look something like this; 12345-1234-ABC-40-CG1 12345-2868-ACC-40-CG1 12345-4897-ACC-40-CG1 12345-7874-BGC-40-CG1 12345-8756-BXC-40-CG1 12348-123-ABC-40-CG1

Stuck string on ceiling fan/light combo light side [ 1 Answers ]

I have a ceiling fan/single light combo, and the pull string to switch on the light is stuck... How do I dismantle the light fixture part to get at the string?. Will I need to replace anything inside?

New string in string Trimer [ 1 Answers ]

How do I put new string in string Trimer. Bump Type kevant

View more questions Search