Column with parts of Filename

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
Phlashman
Posts: 41
Joined: Sun Sep 11, 2022 4:57 am

Column with parts of Filename

Post by Phlashman »

Have filenames of format, where x's are alphanumeric and vary in number, while n's and m's are numerical

xxxx-nnnn-mmm
xxxxx-nnnn-mmm

Need to have a column with "nnnn mmm"

How? I found

addcolumn:A A:=regexextract($name:"-(\d{4})")

will get me column A with "nnnn", but how do I get the second part "mmm" separated by space in the same column (minus the "-" between them)?

Thanks

Everything: 1.5.0.1363a (x64)
OS: Windows NT 10.0 19045 (x64)
void
Developer
Posts: 16748
Joined: Fri Oct 16, 2009 11:31 pm

Re: Column with parts of Filename

Post by void »

Please try the following search:

regex:-(\d{4})-(\d{3}) addcolumn:a a:=$1:" "$2:



Simpler search, but doesn't replace the - with a space:

addcolumn:regmatch1 regex:-(\d{4}-\d{3})
Post Reply