<div>
Another REGEX wizard to the rescue! Thanks!
</div>


<div>
And this part:<br />
&nbsp; &nbsp; [0-9]{8}<br />
can be abbreviated to:<br />
&nbsp; &nbsp; \d{8}
</div>


<div>
And &nbsp;<br />
&nbsp; .<br />
should be<br />
&nbsp;\.
</div>


<div>
And you might like to put a $ near the end like:<br />
&nbsp; &nbsp; xlsx$/<br />
if you want to ensure it matches nothing after that, like:<br />
&nbsp; &nbsp; TESTY_ClinicalQ_20171104.x<wbr />lsx.old
</div>


<div>
<div class="content wysiwyg-content">
I need a perl search string to validate filenames as I iterate through them.<br />
<br />
The filenames should all:<br />
Have 25 characters plus the extension (.xlsx), for example: TESTY_ClinicalQ_20171104.x<wbr />lsx<br />
First 5 characters: caps alphabetic<br />
underscore<br />
&quot;ClinicalQ&quot; just as it is (first character capital C, then lowercase &quot;linical&quot;, then capital Q)<br />
underscore<br />
Then 8 numeric characters<br />
.xlsx
</div>
</div>


I need a perl search string to validate filenames as I iterate through them.

The filenames should all:
Have 25 characters plus the extension (.xlsx), for example: TESTY_ClinicalQ_20171104.xlsx
First 5 characters: caps alphabetic
underscore
"ClinicalQ" just as it is (first character capital C, then lowercase "linical", then capital Q)
underscore
Then 8 numeric characters
.xlsx

Perl search string, validation

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.

Perl

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.