• [font="Arial Black"]NOTICE: BECAUSE OF ONE OF THE EXTREMELY WIDE POSTS ABOVE, YOU MIGHT NOT BE

    ABLE TO TELL THAT THERE ARE MORE PAGES ON THIS THREAD. SCROLL ALL THE WAY DOWN OR ALL THE WAY

    UP AND THEN ALL THE WAY TO THE RIGHT TO GET TO THE "Page x of y" PAGE CLICKABLE LINKS.

    A POSSIBLE SOLUTION COMPLETE WITH TEST DATA CAN BE FOUND ON THE POST AFTER THIS ONE,

    WHICH MIGHT BE ON THE NEXT PAGE FOR YOU DEPENDING ON YOUR FORUM SETTINGS.

    [/font]

    rsrvas (9/4/2015)


    Ignore earlier thread also

    "First A not followed by a B, C or D statement" means "A is present before B, C or D" need to ignore

    i am explaining again with simple text.This is almost same text as mentioned earlier. JUST "VEERNDAR" replaced with "VEERNDR"

    "AXNARENDR" replaced with "AXNRENDR" for getting expected result as i mentioned in the scenario (Its my mistake..i really sorry for this)

    TEXT 1: 'ABNAGENDRACSURENDRADJITHENDRAXNRENDRABVEERNDRAXDRMNDRAXRVINDRABNAGENDRACSURENDRADJITHEN'

    I break it in into substrings for understanding.when substrings concatenated will get TEXT

    ABNAGENDR

    ACSURENDR

    ADJITHENDR

    AXNRENDR

    ABVEERNDR

    AXDRMNDR

    AXRVINDR

    ABNAGENDR

    ACSURENDR

    ADJITHEN'

    From the above text1, I want to get “AXNRENDR”.(This is first substring which is having A other than "B" or "C" or "D",i.e AX)

    from the above substrings/TEXT, My concern is "A with B" or "A with C" or "A with D" occured N times before "A with X" (Here X is dynamic,It can be any character other than "B" or "C" or "D") looking code how to find “AXNRENDR”

    Ah... I think I'm finally baggin' what you're rakin'. I couldn't figure out what you wanted for the length of each string but I think I get it now. Correct me if I'm wrong, please...

    1. You simply want to use the letter "A" as an "inclusive" delimiter to split the "words" out of the string.

    2. Then, you want the FIRST word out of that set (all the "words" start with "A" by definition) that does NOT contain a "B", "C", or "D" for the second letter of the word.

    That does leave a question though. What do you want to return for the following string?

    AAEEEABBBBB

    According to the rules above, that should return only the letter "A".

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)