With element_count does this show the number of matching properties?

[anmac1789]

I'll consider throttling and max counts.
Thank you for the suggestions.


The following might be helpful:

Shows all property values in Column 1:

Code: Select all

addcolumns:column1 column1:=TEXTJOIN(",",true,$35mm-focal-length:,$album:,$album-artist:,$alignment-requirement:,$allocation-size:,$alternate-data-stream-ansi:,$alternate-data-stream-count:,$alternate-data-stream-hex:,$alternate-data-stream-names:,$alternate-data-stream-text-plain:,$alternate-data-stream-utf-16:,$alternate-data-stream-utf-16be:,$alternate-data-stream-utf-8:,$altitude:,$aperture:,$artist:,$aspect-ratio:,$attributes:,$audio-bit-rate:,$audio-bits-per-sample:,$audio-channels:,$audio-format:,$audio-sample-rate:,$authors:,$author-url:,$available-free-disk-size:,$beats-per-minute:,$binary-type:,$bit-depth:,$brightness:,$byte-offset-for-partition-alignment:,$byte-offset-for-sector-alignment:,$byte-order-mark:,$camera-maker:,$camera-model:,$camera-serial-number:,$case-sensitive-dir:,$category:,$character-count:,$character-encoding:,$child-count:,$child-count-from-disk:,$child-file-count:,$child-file-count-from-disk:,$child-folder-count:,$child-folder-count-from-disk:,$child-occurrence-count:,$child-size:,$cluster-size:,$color-representation:,$column-0:,$column-1:,$column-2:,$column-3:,$column-4:,$column-5:,$column-6:,$column-7:,$column-8:,$column-9:,$column-a:,$column-b:,$column-c:,$column-d:,$column-e:,$column-f:,$comment:,$company:,$composer:,$compressed-bits-per-pixel:,$compressed-size:,$compression:,$compression-chunk-shift:,$compression-cluster-shift:,$compression-format:,$compression-ratio:,$compression-unit-shift:,$computer:,$conductor:,$container-file-count:,$container-filenames:,$content:,$content-created:,$content-provider:,$content-status:,$content-type:,$contrast:,$copyright:,$crc-32:,$crc-64:,$custom-property-0:,$custom-property-1:,$custom-property-2:,$custom-property-3:,$custom-property-4:,$custom-property-5:,$custom-property-6:,$custom-property-7:,$custom-property-8:,$custom-property-9:,$date-accessed:,$date-acquired:,$date-changed:,$date-created:,$date-indexed:,$date-modified:,$date-printed:,$date-received:,$date-recently-changed:,$date-released:,$date-run:,$date-saved:,$date-sent:,$date-taken:,$day-accessed:,$day-created:,$day-modified:,$delete-pending:,$descendant-count:,$descendant-file-count:,$descendant-folder-count:,$description:,$digital-zoom:,$dimensions:,$director:,$display-full-path:,$display-name:,$document-content-type:,$drive-type:,$effective-physical-bytes-per-sector-for-atomicity:,$encoded-by:,$encryption-status:,$end-of-file:,$exif-version:,$exposure-bias:,$exposure-program:,$exposure-time:,$extension:,$extension-frequency:,$extension-length:,$file-id:,$file-list-filename:,$file-list-full-path:,$filename-length:,$filename-utf-8-byte-length:,$file-signature:,$file-storage-info-flags:,$file-system:,$file-system-flags:,$first-128-bytes:,$first-16-bytes:,$first-256-bytes:,$first-2-bytes:,$first-32-bytes:,$first-4-bytes:,$first-512-bytes:,$first-64-bytes:,$first-8-bytes:,$first-byte:,$flash-energy:,$flash-maker:,$flash-mode:,$flash-model:,$focal-length:,$folder-depth:,$frame-count:,$frame-rate:,$free-disk-size:,$from:,$f-stop:,$full-path:,$full-path-length:,$full-path-utf-8-byte-length:,$genre:,$group-description:,$hard-link-count:,$hard-link-filenames:,$height:,$hidden-slide-count:,$horizontal-resolution:,$host-url:,$icon:,$image-id:,$incur-seek-penalty:,$index-number:,$index-type:,$index-volume-label:,$initial-key:,$is-directory:,$is-folder:,$iso-speed:,$kind:,$language:,$last-128-bytes:,$last-16-bytes:,$last-256-bytes:,$last-2-bytes:,$last-32-bytes:,$last-4-bytes:,$last-512-bytes:,$last-64-bytes:,$last-8-bytes:,$last-author:,$last-byte:,$latitude:,$length:,$lens-maker:,$lens-model:,$light-source:,$line-count:,$links-dirty:,$logical-bytes-per-sector:,$longitude:,$machine-target:,$maker-note:,$manager:,$max-aperture:,$max-child-depth:,$maximum-component-length:,$md5:,$md5sum-md5:,$md5sum-pass:,$media-created:,$metering-mode:,$mood:,$name:,$name-frequency:,$note-count:,$offline-availability:,$offline-status:,$online:,$opened-by:,$orientation:,$original-filename:,$out-of-date:,$owner:,$page-count:,$paragraph-count:,$parental-rating:,$parental-rating-reason:,$parent-file-id:,$parent-name:,$parent-path:,$parse-full-path:,$parse-name:,$part-of-a-compilation:,$part-of-set:,$path:,$path-length:,$people:,$perceived-type:,$period:,$photometric-interpretation:,$physical-bytes-per-sector-for-atomicity:,$physical-bytes-per-sector-for-performance:,$plain-text-line-count:,$presentation-format:,$producer:,$product-name:,$product-version:,$promotion-url:,$protected:,$publisher:,$randomize:,$rating:,$referrer-url:,$regular-expression-match-0:,$regular-expression-match-1:,$regular-expression-match-2:,$regular-expression-match-3:,$regular-expression-match-4:,$regular-expression-match-5:,$regular-expression-match-6:,$regular-expression-match-7:,$regular-expression-match-8:,$regular-expression-match-9:,$regular-expression-matches-1-9:,$related-sound-file:,$remote-protocol:,$remote-protocol-flags:,$remote-protocol-version:,$reparse-tag:,$reparse-target:,$resolution-unit:,$revision-number:,$root-name:,$row:,$run-count:,$saturation:,$scale:,$sector-size:,$sfv-crc-32:,$sfv-pass:,$sha-1:,$sha1sum-pass:,$sha1sum-sha-1:,$sha-256:,$sha256sum-pass:,$sha256sum-sha-256:,$sha-384:,$sha-512:,$sha512sum-pass:,$sha512sum-sha-512:,$shared-with:,$sharpness:,$shell-attributes:,$shortcut-target:,$short-full-path:,$short-name:,$shutter-speed:,$sibling-count:,$sibling-file-count:,$sibling-folder-count:,$size:,$size-frequency:,$size-on-disk:,$slide-count:,$software:,$stem:,$stem-length:,$subject:,$subject-distance:,$subtitle:,$tags:,$template:,$thumbnail:,$time-accessed:,$time-created:,$time-modified:,$title:,$to:,$total-alternate-data-stream-size:,$total-alternate-data-stream-size-on-disk:,$total-bit-rate:,$total-disk-size:,$total-editing-time:,$total-size:,$total-size-on-disk:,$track:,$trademarks:,$transcoded-for-sync:,$type:,$url:,$used-disk-size:,$valid-utf-8:,$version:,$version-number:,$vertical-resolution:,$video-bit-rate:,$video-format:,$volume-label:,$volume-name:,$volume-path:,$volume-serial-number:,$white-balance:,$width:,$word-count:,$writer:,$year:,$zone-id:)

Shows the total property value count in Column 1:

Code: Select all

addcolumns:column1 column1:=ELEMENTCOUNT(TEXTJOIN(",",true,$35mm-focal-length:,$album:,$album-artist:,$alignment-requirement:,$allocation-size:,$alternate-data-stream-ansi:,$alternate-data-stream-count:,$alternate-data-stream-hex:,$alternate-data-stream-names:,$alternate-data-stream-text-plain:,$alternate-data-stream-utf-16:,$alternate-data-stream-utf-16be:,$alternate-data-stream-utf-8:,$altitude:,$aperture:,$artist:,$aspect-ratio:,$attributes:,$audio-bit-rate:,$audio-bits-per-sample:,$audio-channels:,$audio-format:,$audio-sample-rate:,$authors:,$author-url:,$available-free-disk-size:,$beats-per-minute:,$binary-type:,$bit-depth:,$brightness:,$byte-offset-for-partition-alignment:,$byte-offset-for-sector-alignment:,$byte-order-mark:,$camera-maker:,$camera-model:,$camera-serial-number:,$case-sensitive-dir:,$category:,$character-count:,$character-encoding:,$child-count:,$child-count-from-disk:,$child-file-count:,$child-file-count-from-disk:,$child-folder-count:,$child-folder-count-from-disk:,$child-occurrence-count:,$child-size:,$cluster-size:,$color-representation:,$column-0:,$column-1:,$column-2:,$column-3:,$column-4:,$column-5:,$column-6:,$column-7:,$column-8:,$column-9:,$column-a:,$column-b:,$column-c:,$column-d:,$column-e:,$column-f:,$comment:,$company:,$composer:,$compressed-bits-per-pixel:,$compressed-size:,$compression:,$compression-chunk-shift:,$compression-cluster-shift:,$compression-format:,$compression-ratio:,$compression-unit-shift:,$computer:,$conductor:,$container-file-count:,$container-filenames:,$content:,$content-created:,$content-provider:,$content-status:,$content-type:,$contrast:,$copyright:,$crc-32:,$crc-64:,$custom-property-0:,$custom-property-1:,$custom-property-2:,$custom-property-3:,$custom-property-4:,$custom-property-5:,$custom-property-6:,$custom-property-7:,$custom-property-8:,$custom-property-9:,$date-accessed:,$date-acquired:,$date-changed:,$date-created:,$date-indexed:,$date-modified:,$date-printed:,$date-received:,$date-recently-changed:,$date-released:,$date-run:,$date-saved:,$date-sent:,$date-taken:,$day-accessed:,$day-created:,$day-modified:,$delete-pending:,$descendant-count:,$descendant-file-count:,$descendant-folder-count:,$description:,$digital-zoom:,$dimensions:,$director:,$display-full-path:,$display-name:,$document-content-type:,$drive-type:,$effective-physical-bytes-per-sector-for-atomicity:,$encoded-by:,$encryption-status:,$end-of-file:,$exif-version:,$exposure-bias:,$exposure-program:,$exposure-time:,$extension:,$extension-frequency:,$extension-length:,$file-id:,$file-list-filename:,$file-list-full-path:,$filename-length:,$filename-utf-8-byte-length:,$file-signature:,$file-storage-info-flags:,$file-system:,$file-system-flags:,$first-128-bytes:,$first-16-bytes:,$first-256-bytes:,$first-2-bytes:,$first-32-bytes:,$first-4-bytes:,$first-512-bytes:,$first-64-bytes:,$first-8-bytes:,$first-byte:,$flash-energy:,$flash-maker:,$flash-mode:,$flash-model:,$focal-length:,$folder-depth:,$frame-count:,$frame-rate:,$free-disk-size:,$from:,$f-stop:,$full-path:,$full-path-length:,$full-path-utf-8-byte-length:,$genre:,$group-description:,$hard-link-count:,$hard-link-filenames:,$height:,$hidden-slide-count:,$horizontal-resolution:,$host-url:,$icon:,$image-id:,$incur-seek-penalty:,$index-number:,$index-type:,$index-volume-label:,$initial-key:,$is-directory:,$is-folder:,$iso-speed:,$kind:,$language:,$last-128-bytes:,$last-16-bytes:,$last-256-bytes:,$last-2-bytes:,$last-32-bytes:,$last-4-bytes:,$last-512-bytes:,$last-64-bytes:,$last-8-bytes:,$last-author:,$last-byte:,$latitude:,$length:,$lens-maker:,$lens-model:,$light-source:,$line-count:,$links-dirty:,$logical-bytes-per-sector:,$longitude:,$machine-target:,$maker-note:,$manager:,$max-aperture:,$max-child-depth:,$maximum-component-length:,$md5:,$md5sum-md5:,$md5sum-pass:,$media-created:,$metering-mode:,$mood:,$name:,$name-frequency:,$note-count:,$offline-availability:,$offline-status:,$online:,$opened-by:,$orientation:,$original-filename:,$out-of-date:,$owner:,$page-count:,$paragraph-count:,$parental-rating:,$parental-rating-reason:,$parent-file-id:,$parent-name:,$parent-path:,$parse-full-path:,$parse-name:,$part-of-a-compilation:,$part-of-set:,$path:,$path-length:,$people:,$perceived-type:,$period:,$photometric-interpretation:,$physical-bytes-per-sector-for-atomicity:,$physical-bytes-per-sector-for-performance:,$plain-text-line-count:,$presentation-format:,$producer:,$product-name:,$product-version:,$promotion-url:,$protected:,$publisher:,$randomize:,$rating:,$referrer-url:,$regular-expression-match-0:,$regular-expression-match-1:,$regular-expression-match-2:,$regular-expression-match-3:,$regular-expression-match-4:,$regular-expression-match-5:,$regular-expression-match-6:,$regular-expression-match-7:,$regular-expression-match-8:,$regular-expression-match-9:,$regular-expression-matches-1-9:,$related-sound-file:,$remote-protocol:,$remote-protocol-flags:,$remote-protocol-version:,$reparse-tag:,$reparse-target:,$resolution-unit:,$revision-number:,$root-name:,$row:,$run-count:,$saturation:,$scale:,$sector-size:,$sfv-crc-32:,$sfv-pass:,$sha-1:,$sha1sum-pass:,$sha1sum-sha-1:,$sha-256:,$sha256sum-pass:,$sha256sum-sha-256:,$sha-384:,$sha-512:,$sha512sum-pass:,$sha512sum-sha-512:,$shared-with:,$sharpness:,$shell-attributes:,$shortcut-target:,$short-full-path:,$short-name:,$shutter-speed:,$sibling-count:,$sibling-file-count:,$sibling-folder-count:,$size:,$size-frequency:,$size-on-disk:,$slide-count:,$software:,$stem:,$stem-length:,$subject:,$subject-distance:,$subtitle:,$tags:,$template:,$thumbnail:,$time-accessed:,$time-created:,$time-modified:,$title:,$to:,$total-alternate-data-stream-size:,$total-alternate-data-stream-size-on-disk:,$total-bit-rate:,$total-disk-size:,$total-editing-time:,$total-size:,$total-size-on-disk:,$track:,$trademarks:,$transcoded-for-sync:,$type:,$url:,$used-disk-size:,$valid-utf-8:,$version:,$version-number:,$vertical-resolution:,$video-bit-rate:,$video-format:,$volume-label:,$volume-name:,$volume-path:,$volume-serial-number:,$white-balance:,$width:,$word-count:,$writer:,$year:,$zone-id:),",")

This would give you complete control over what properties to show.
This will also show just how incredibly slow it is to gather/calculate all property values.

Column Formulas

With element_count does this show the number of matching properties? for example lets say a file has filename = test.jpg in 6 different locations all with the same name then will column1 show 6 for all 6 of these filenames using element_count ? what information does element_count show exactly ? in relation to what ?

[void]

Moved from Column that provides Count of Properties with Values.

ELEMENTCOUNT(list,delimiter-characters) will count the number of items in the specified list.

For example:

Count the number of items in the list "abc;123;xyz" using ; as the separator character:
ELEMENTCOUNT("abc;123;xyz",";") => 3

ELEMENTCOUNT(list,delimiter-characters)



There's currently no method to count the number of duplicates in Everything.

[anmac1789]

Ok thank you