Results 1 to 2 of 2

Parse String For Folder Search

Threaded View

bdb1974 Parse String For Folder Search 10-18-2010, 04:56 PM
bdb1974 Re: Parse String For Folder... 10-22-2010, 05:43 PM
  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Parse String For Folder Search

    Hi all,

    A few months back I was fortunate enough to have L.Ross help me put some code
    together to which searches for a specific folder by matching a string entry.

    http://www.excelforum.com/excel-prog...-wildcard.html

    This works great but it is rather limited. The string used for the search either has to be single word or strings consisting of multilple words &/ character groups have to be an
    exact match.

    I would like to be able to take the search string and parse it to single out each word or group of characters that are separated by a delimiter ( "",/ .)

    I have found a parsing function that I would like to use.
    http://www.freevbcode.com/ShowCode.Asp?ID=3208

    I'm just not sure how to pass the string to be parsed to the function then have the function
    return each parsed word or character group to the Function FileFolderExists
    I'm pretty sure some changes either will have to be made to either one or both functions:

    Function FileFolderExists
    Function parse

    I believe the parse function outpus an array, this I would like to pass to FileFolderExists function then have it search on the filter like:


    
    Filter =  arrayCodes()
     ' Filter = "array(1)|array(2)|array(3)|array(N+1)" 
    If Folder.Name Like Filter Then
    'do this.

    I hope all this makes sense.
    Any Help is greatly appreciated.

    Thanks,

    BDB
    Last edited by bdb1974; 10-22-2010 at 05:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1