Extract file name

From: Steven <Steven@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 8 Aug 2008 16:23:00 -0700

What function would extact the name: 84DTCC 2008_05
out of this.
G:\CorporateAcct\SMR\Special\Support\84DTCC 2008_05.pdf

Note that the directory and subdirectory(ies) will not be constant (ie.
some may have more or less "\" )

Thank you,

Steven
.

Follow-Ups:
- Re: Extract file name
  - From: Dana DeLouis
- Re: Extract file name
  - From: Rick Rothstein \(MVP - VB\)
- Re: Extract file name
  - From: Ron Rosenfeld

Prev by Date: Re: Challenge with target output
Next by Date: Re: Extract file name
Previous by thread: Counting number of pay period dates between 2 numbers
Next by thread: Re: Extract file name
Index(es):
- Date
- Thread