On Fri, 15 Feb 2008 23:00:40 -0500, "Rick Rothstein \(MVP -
VB\)"
wrote:
The above as a "one-liner" in deference to Rick:
LOL
============================================
Function fn(str As String) As String
fn = Trim(Split(Split(str, "\")(UBound(Split _
(str, "\"))), "-")(LBound(Split(Split _
(str, "\")(UBound(Split(str, "\"))), "-"))))
End Function
==========================================
The LBound for a Split is always 0 no matter what the Option Base is set to.
Using this fact, your one-liner can be simplified considerably...
Function fn(str As String) As String
fn = Trim(Split(Split(str, "\")(UBound(Split(str, "\"))), "-")(0))
End Function
And you've told me that before <grrr <slap upside my head
--ron