"The regular expression search checks to see if the input file
name can be broken into a file name part and a sheet name part. If
it can, and only if the original unbroken input file name does not
refer to an existing file, the pieces are used as the input file
and sheet specification. Checking to see if the original unbroken
input file name refers to an existing file allows you to specify
input files that have colons and at signs in their names, and it
continues to work even in the case where you have an input file
with a colon or at sign in its name and you want to extract a
particular sheet, for example:
"will correctly recognize that the sheet name is "sales" and
that the file name is "this:month.xls". Since the regular
expression search is be default greedy the break will occur at the
last colon and since "this:month.xls:sales" does not refer to an
existing file the match will be used."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.