Chris Morris-439714 (9/20/2010)
keith-710920 (9/20/2010)
Perhaps I'm missing something here, but no where in Dave's original query did he mention anything about parsing folder structures, parsing multiple strings or anything like that. He simply asked how to take a single string which he already has (presumably from some other code he already knows how to write) and pull out a particular substring.You are absolutely right Keith, at least about the latter part. ColdCoffee & I posted our column-centric solutions because - well, because that's what is usually asked for. Both solutions will work with a string variable with a little simple modification.
I absolutely agree with u Morris, the solution i prepared (and the one u prepared) are column-centric ; a lot of folks, for brevity sake, show only a row of data they actually have. BUt it is always better to provide a column-centric solution.
@keith, as Morris said, its just a matter of replacing the column name with local variable name, should it be a request to parse local variable.