Using fileStats() Function

fileStats(filePath, type)

This function returns:

EXIF tags for files representing photos (saved by digital cameras) and any other JPG/TIFF/PNG/BMP/ICO images.
Various multimedia-related metadata for multimedia (video/sound) files.

filePath

A textual field containing full file paths (or a directly entered fixed string). File paths from a given folder or entire disk partitions can be loaded with the "Tools > Verify Files" functions.

type

A numeric code representing one of two types of extracted tags, depending on the file type:
if the path points to a photo or other JPG/TIFF/PNG/BMP/ICO image, this code represents an extracted EXIF tag;
if the path points to a multimedia video or sound file, this code represents multimedia file metadata.

NOTE: this function should be used in calculated Text fields.
For best performance for very large tables that you update at once, increase the number of processor cores used for calculations in the Settings > Options > General window.

=fileStats(images, 1)    returns the GPS latitude for the location where the image was taken
=fileStats("e:\photo3.jpg", 6)    returns the GPS altitude for the location where the image was taken
=fileStats(images, hex2dec("132"))    returns the 0x132 property value (a date) for a given image
=fileStats(images, -1)    returns the list of all EXIF tags encoded in a given image

=fileStats(videos, 3)
=fileStats("e:\some_file.avi", 3)
=fileStats(videos, 20)
=fileStats(videos, 11)

EXIF Property Codes

EXIF property value (hexadecimal) codes for photos and other JPG/TIFF/EXIF/PNG/BMP/ICO images:

Tag	Code	Tag	Code
ImageWidth	`0x100`	ImageHeight	`0x101`
EquipMake	`0x10f`	EquipModel	`0x110`
Orientation	`0x112`	XResolution	`0x11a`
YResolution	`0x11b`	ResolutionUnit	`0x128`
SoftwareUsed	`0x131`	DateTime	`0x132`
YCbCrPositioning	`0x213`	ExifExposureTime	`0x829a`
ExifFNumber	`0x829d`	ExifExposureProg	`0x8822`
ExifISOSpeed	`0x8827`	ExifVer	`0x9000`
ExifDTOrig	`0x9003`	ExifDTDigitized	`0x9004`
ExifCompConfig	`0x9101`	ExifShutterSpeed	`0x9201`
ExifAperture	`0x9202`	ExifBrightness	`0x9203`
ExifExposureBias	`0x9204`	ExifMaxAperture	`0x9205`
ExifSubjectDist	`0x9206`	ExifMeteringMode	`0x9207`
ExifFlash	`0x9209`	ExifFocalLength	`0x920a`
ExifMakerNote	`0x927c`	ExifDTSubsec	`0x9290`
ExifDTOrigSS	`0x9291`	ExifDTDigSS	`0x9292`
ExifFPXVer	`0xa000`	ExifColorSpace	`0xa001`
ExifPixXDim	`0xa002`	ExifPixYDim	`0xa003`
ExifSensingMethod	`0xa217`	ExifSceneType	`0xa301`
GpsVer	`0x0`	GpsLatitudeRef	`0x1`
GpsLatitude	`0x2`	GpsLongitudeRef	`0x3`
GpsLongitude	`0x4`	GpsAltitudeRef	`0x5`
GpsAltitude	`0x6`	GpsGpsTime	`0x7`
GpsGpsDop	`0xb`	ThumbnailData	`0x501b`
ThumbnailImageWidth	`0x5020`	ThumbnailImageHeight	`0x5021`
ThumbnailCompression	`0x5023`	ThumbnailOrientation	`0x5029`
ThumbnailResolutionX	`0x502d`	ThumbnailResolutionY	`0x502e`
ThumbnailResolutionUnit	`0x5030`	JPEGInterFormat	`0x201`
JPEGInterLength	`0x202`	ChrominanceTable	`0x5091`
LuminanceTable	`0x5090`	ICCProfile	`0x8773`

Multimedia Metadata Codes

Multimedia metadata tag codes for video/sound files:

Code	Description
1	Digital Living Network Alliance(DLNA) profile identifier.
2	Number of audio channels.
3	Average audio bit rate, in bits per second.
4	Audio subtype.
5	Indicates whether the audio stream uses variable bit-rate encoding.
6	Peak volume level of audio content.
7	Audio sample rate in samples per second.
8	Number of bits per audio sample.
9	Identifier of the audio stream.
10	Author.
11	A comment attached to a file.
12	Copyright information.
13	Indicates whether the content is protected using digital rights management.
14	Keywords.
15	Language.
16	URL of the author's website.
17	Average volume level of audio content.
18	The string representation of a GUID that identifies the primary class of media.
19	The string representation of a GUID that identifies the secondary class of media.
20	The string representation of a GUID that identifies the collection group.
21	The string representation of a GUID that identifies the collection.
22	Distributor of the content.
23	The string representation of a GUID that identifies the collection.
24	Time when the content was encoded.
25	Original release date.
26	Duration, in 100-nanosecond units.
27	Digital video disc identifier.
28	Name of the person or group that encoded the content.
29	Description of the settings used to encode the content.
30	Music CD identifier. This value is used to identify a CD.
31	Name of the metadata content provider.
32	Name of the producer of the content.
33	URL of a website offering a promotion related to the content.
34	Rating of the content as assigned by the metadata content provider.
35	Style or genre of the content as assigned by the metadata content provider.
36	Publisher.
37	Subtitle.
38	A generic string that can be used to identify the file.
39	Writer.
40	Year the content was published.
41	Primary artist for the album.
42	Album title.
43	Artist.
44	Beats per minute.
45	Composer.
46	Conductor.
47	Description of the content (boxed set or series).
48	Genre.
49	The initial key of the music.
50	Indicates whether the music file is part of a compilation.
51	Lyrics.
52	Mood.
53	The part number and the total number of parts.
54	Period.
55	Track number.
56	Parental rating.
57	Reasons for the assigned parental rating.
58	User rating.
59	Thumbnail image.
60	Title.
61	Video subtype.
62	Director.
63	Average video bit rate, in bits per second.
64	The FOURCC of the video encoding format.
65	Video frame height.
66	Video frame rate, expressed as frames per second × 1000.
67	Video frame width.
68	The horizontal component of the pixel aspect ratio.
69	Indicates whether the video stream contains stereo video content.
70	Identifier of the video stream.
71	Total data rate for all video and audio streams, in bits per second.