Re: RegEx question, hopefully easy

> Lets say I have this string -
> 
> CC: Apparel : Red Shoes : Prints : Madden
> 
> *there might be a case where there is no space before or after the ":".
> 
> Why I want is to extract "Madden", basically all non-space chars after the last ":" or if anchoring from the back, all chars up to ":" (not including the : or space).


Not rigorously tested, but something along the lines of:

	SET var = string.split('\s*:\s*');
	SET keep = var.last ;

... ought to be pretty close to what you need.

cheers
RET
______________________________________________________
Don't anthropomorphize computers. They hate that.