Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcard for numeric characters in filename?
I need to consolidate data from many files in a directory with
filenames in the form of [variable length text name][4-digit number].xls For example: alpha0104.xls alpha0204.xls beta0104.xls gamma0204.xls omicron0704.xls etc... There are also other files in the directory not of this format that I will ignore. In some cases, I need all the files of the same name, regardless of the number. I can build a filename string like "alpha????.xls", which works fine. Or, if I need all the files of the same number, I can use "*0104.xls" which also works. However, if I want all the files in this format that begin with the letter a, "a*????.xls" will not work because it picks up other files that I don't want. I tried "a*####.xls", which theoretically would work perfectly for my application, but the # is apparently not a valid wildcard for numeric-only characters in a filename. Is there some wildcard for numeric characters in filenames, or can someone suggest a different approach? Thanks, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can wildcard characters be used in IF functions | Excel Worksheet Functions | |||
Wildcard for finding the first numeric digit in a cell? | Excel Worksheet Functions | |||
wildcard characters | Excel Discussion (Misc queries) | |||
HELP: Wildcard Characters | Excel Discussion (Misc queries) | |||
WildCard Characters | Excel Worksheet Functions |