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)
Column with parts of Filename
Re: Column with parts of Filename
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})
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})