Oh, I see. Well in the StackOverflow post, substr(starting_word,1,pos-2); is used to return a string that includes all but the last word. You'll probably need this: call scan(original_string, 2, pos, length); to get the length and position of the second word, then first_piece = substr(original_string, 1, pos-1) (maybe pos-2 to remove the space between the words) and second_piece = substr(original_string, pos+length, lengthOfString) (you'll have to calculate lengthOfString using the LENGTH function) Then use a CAT function (see here for a good description of the different choices) to combine first_piece and second_piece.
... View more