Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.misc > #9197

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

Show all headers | View raw

On 2024-04-30, Dudley Brooks <dbrooks@runforyourlife.org> wrote:
> On 4/30/24 8:56 AM, Jolly Roger wrote:
>
>> 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,
>
> Thanks!  That's EXACTLY what I'm looking for.
>
> Ironically, I had actually done "man stat" ... but I didn't see all 
> those formatting parameters.  I must have been looking way too late at 
> night ... when my brain turns into a pumpkin.
>
>> I would use comma characters for delimiters to make it a CSV file, then
>> open that in a spreadsheet program.
>
> I was just thinking about that.  Thanks!  (I think Excel can separate on 
> tabs as well, though.  But it's always good to have different options. 
> And maybe it saves you from having to do copy-and-paste.)
>
> One more thing, if either of you knows why this might be:
>
> If <filename> has not already been created, I get an error message.
>
> If I create <filename> first, there's no error message, and it seems to 
> be running fine ... except ... it doesn't seem to do anything -- nothing 
> gets written to <filename>!
>
> Any ideas?  Maybe it's another casualty of over-full HD?

What is the command you are using, and what is the error output?

-- 
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 | Unroll thread

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