how to use a filter using regex in Coldfusion

Question

New to coldfusion, new to regex...

I have a directory of files, named with "some" followed by a 13digit number, followed by underscore, ID and file ending like so:

  some0000000000000_ID.jpg

ID can be any string.

How would I get the ID using regex? I guess I'd be looking for something like this, which captures everything between the underscore and file ending dot:

  _\A[A-Z]*[a-z]*[0-9]*$

but I'm really not getting anywhere. Can someone point me in the right direction?

Thanks!

EDIT:
I ended up doing it like this, which is hack-ish but works nicely:

<cfset cropFront = #ListRest(ReReplaceNoCase(name, ".png|.jpg", ""), "_")#>
<cfset cropFull = #ListFirst(ReReplaceNoCase( cropFront, "xxxxx", ""), "." )#> 

Maybe useful for someone else, too!

Answer 1

<cfdirectory name="images" directory="#path#" filter="some?????????????_ID.jpg">

The filter is not a regex pattern. It only knows the ? and * wildcard characters.

Answer 2

Can't test at the moment but this is the idea...

<cfdirectory name="files" directory="path" action="list" />

<cfloop query="files">
    <cfset findinfo = refind("^some(\d{13})_", files.name, 0, true) />
    <cfif arraylen(findinfo.pos) eq 2>
        <cfset fileid = mid(files.name, findinfo.pos[2], findinfo.len[2]) />
        <!--- do something --->
    </cfif>
</cfloop>