Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra)

From	Jolly Roger <jollyroger@pobox.com>
Newsgroups	comp.sys.mac.misc
Subject	Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra)
Date	2024-04-30 15:56 +0000
Organization	People for the Ethical Treatment of Pirates
Message-ID	<l9cileF5vsU1@mid.individual.net> (permalink)
References	<v0piqb$232f5$1@dont-email.me> <l9b5nmFo4r1U1@mid.individual.net>

Show all headers | View raw

On 2024-04-30, Jim Gibson <jimsgibson@gmail.com> wrote:
> On Apr 29, 2024 at 6:51:05 PM PDT, "Dudley Brooks"
><dbrooks@runforyourlife.org> wrote:
>
>> I want to print out all the File Names, their Creation Dates, and their
>> Modification Dates.  (Printing all the other info is fine too.)  If
>> possible, I would like to do it in a form that can be easily put into a
>
> You can use the stat utility in a command-line shell in the Terminal
> application to print out creation and modification times for any file.
>
> Use 'man stat' for details. Use the -f option to specifiy the content and
> format for the fields to be displayed.
>
> You want the following format specifiers:
>
>     %SN  to display the file name
>     %SB  to display the creation (birth) time
>     %Sm  to display the modification time
>     %t    to insert tab characters between fields
>
> So the following should give you what you want:
>
>     stat -f '%SN%t%SB%t%Sm' *
>
> Redirect the output to a file:
>
>     stat -f '%SN%t%SB%t%Sm' * > file_times.txt
>
> and you can import that into a spreadsheet specifying tab characters to
> separate columns,

I would use comma characters for delimiters to make it a CSV file, then
open that in a spreadsheet program.

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

Back to comp.sys.mac.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-04-29 18:51 -0700
  Re: Print (or export to a spreadsheet) all the information displayed when   Finder is looking at a folder (OS X 10.13 High Sierra) Jim Gibson <jimsgibson@gmail.com> - 2024-04-30 03:09 +0000
    Re: Print (or export to a spreadsheet) all the information displayed when   Finder is looking at a folder (OS X 10.13 High Sierra) Jolly Roger <jollyroger@pobox.com> - 2024-04-30 15:56 +0000
      Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-04-30 14:22 -0700
        Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Jolly Roger <jollyroger@pobox.com> - 2024-04-30 22:56 +0000
          Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-05-01 19:44 -0700
            Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Jolly Roger <jollyroger@pobox.com> - 2024-05-02 15:37 +0000
              Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Jolly Roger <jollyroger@pobox.com> - 2024-05-02 15:42 +0000
                Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-05-02 10:34 -0700
                Another question Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-05-03 11:50 -0700
                Re: Another question Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Jolly Roger <jollyroger@pobox.com> - 2024-05-04 20:43 +0000
                Re: Another question Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-05-29 17:34 -0700
                Re: Another question Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Jolly Roger <jollyroger@pobox.com> - 2024-05-30 00:43 +0000
                Re: Another question Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-06-02 16:20 -0700
                Re: Another question Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Your Name <YourName@YourISP.com> - 2024-06-03 12:17 +1200
  Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Your Name <YourName@YourISP.com> - 2024-04-30 15:40 +1200
    Re: Print (or export to a spreadsheet) all the information displayed when Finder is looking at a folder (OS X 10.13 High Sierra) Dudley Brooks <dbrooks@runforyourlife.org> - 2024-04-30 14:27 -0700

csiph-web