linux:extract-metadata
Extract Metadata
Exiftool - while initially used to extract and manipulate EXIF data of image files - can be used to extract meta data for a large amount of files including MS Office xlsx/docx/etc, Openoffice files, videos, audio files etc.
Current list of supported file types: https://www.sno.phy.queensu.ca/~phil/exiftool/#supported
To use, just install it
sudo apt-get install exiftool
then point it to a file, e.g.:
exiftool SmallCap\ Funds\ 2019-10-15.xlsm
Output is as following:
ExifTool Version Number : 10.80 File Name : SmallCap Funds 2019-10-15.xlsm Directory : . File Size : 962 kB File Modification Date/Time : 2019:10:15 16:30:37+01:00 File Access Date/Time : 2019:10:16 18:59:32+01:00 File Inode Change Date/Time : 2019:10:16 18:59:27+01:00 File Permissions : rw------- File Type : XLSM File Type Extension : xlsm MIME Type : application/vnd.ms-excel.sheet.macroEnabled Zip Required Version : 20 Zip Bit Flag : 0x0006 Zip Compression : Deflated Zip Modify Date : 1980:01:01 00:00:00 Zip CRC : 0x828075c7 Zip Compressed Size : 831 Zip Uncompressed Size : 9690 Zip File Name : [Content_Types].xml Application : Microsoft Excel Doc Security : None Scale Crop : No Heading Pairs : Worksheets, 14, Named Ranges, 4 Titles Of Parts : SMCO, AIM VCT, AIM IHT, Quartet Fund, SMCO Top 20, AIM VCT Top 20, AIM IHT Top 20, SMCO weights, AIM VCT Weights, AIM IHT Weights, SMCO Liquidity, AIM VCT Liquidity, AIM IHT Liquidity, Sectors list, DIST_RU_COL, 'Quartet Fund'!Print_Area, SMCO!Print_Area, 'SMCO Top 20'!Print_Area Company : SICO Links Up To Date : No Shared Doc : No Hyperlinks Changed : No App Version : 14.0300 Creator : PC department Description : Last saved:...15/10/2019 16:28:00 Last Modified By : Fidessa Last Printed : 2019:03:07 08:59:16Z Create Date : 2000:04:27 14:51:41Z Modify Date : 2019:10:15 15:28:01Z
linux/extract-metadata.txt · Last modified: 2023/05/29 11:55 by 127.0.0.1