regex search fails on different spellings in ".*"

[wistlo]

The following regular expression is bookmarked to show check pdfs sorted by check number:

Code: Select all

regex:^.*\\.*\\check\x20images\\\d{4}-\d\d-\d\d\x20(\d{4}).*$ addcol:A A:=$1:  a-label:="Checknumber" sort-descending:A

The list of the files (content taken from exported .efu file) is as follows, from the only "check images" directories on my disks. Note the intentionally misspelled filename "plumbing" as plumaing:

When the "plumaing" is changed to "plumbing", the regex fails to find this file. Total count goes from 42 to 41 (so I know it's not just landing somewhere down the list in the sort).

Wish I could make some of these checks disappear so easily, but alas our century-old house is falling apart.

Filename,Size,Date Modified,Date Created,Attributes,Date Taken
"C:\Users\stuart\OneDrive\Documents\2025\! 2025 MONTHLY RECURRING\11 -16 ALLY BANK\m10 Stuart Amy JOINT\check images\2025-09-24 1435 Richie's Plumaing 265.00.pdf",252240,134043245717468129,,0,
"C:\Users\stuart\OneDrive\Documents\2025\! 2025 MONTHLY RECURRING\11 -16 ALLY BANK\m10 Stuart Amy JOINT\check images\2025-09-02 1434 Ronald Richburg #1 final 3500.00.pdf",210787,134014652805776593,134014652802798718,525344,
"C:\Users\stuart\OneDrive\Documents\2025\! 2025 MONTHLY RECURRING\11 -16 ALLY BANK\m10 Stuart Amy JOINT\check images\2025-08-26 1433 Ronald Richburg #5 #7 duct - pier 2nd 9500.00.pdf",207005,134013834666033867,134013834663597752,525344,
.
. complete .efu file is attached, 42 records total
.

"C:\Users\stuart\OneDrive\Documents\2024\! 2024 MONTHLY RECURRING\11-16 ALLY BANK\m11 Amy Joint x1318 x6610 x4737\check images\2024-01-01 1382 AT&T Inc 845.29.pdf",227410,133890359601035548,133890359597435985,525344,

********************* S c r e e n s h o t s *********************

**** Next two shots show Everything working with the "plumaing" spelling. Note that other various spellings sometimes work, but I have not been able to discern a pattern. Machine was rebooted with no other apps running in case this was out-of-memory foolishness.****

image.png

image.png

**** Correct the plumaing to plumbing, and the search fails ****

image.png

image.png

[void]

Without looking into this too much, I think the issue is with

sort-descending:A

sort-descending:

doesn't take any parameters, so Everything will see:

sort-descending:

AND

A

Please try the following search instead:

Code: Select all

regex:^.*\\.*\\check\x20images\\\d{4}-\d\d-\d\d\x20(\d{4}).*$ addcol:A A:=$1:  a-label:="Checknumber" sort:a-descending

Do you see the expected results?



sort-descending:
sort:

[wistlo]

Yes, 'a' standing alone as a parameter was the issue.

This explains how plumaing would work and plumbing would not, or that Richie's Plumbing failed because it had no "a".