Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: List all files and directories in the current directory separated by commas and sorted by crtime
Top Forums UNIX for Beginners Questions & Answers List all files and directories in the current directory separated by commas and sorted by crtime Post 303032167 by Don Cragun on Wednesday 13th of March 2019 03:30:27 AM
Old 03-13-2019
I doubt that this will work on Ubuntu systems either, but it might be worth a try. The operating system I'm using doesn't have the debugfs or findmnt utilities and the date utility doesn't have a -d option, but the following code seems to do what I think you're trying to do.
Code:
crtime-at() {
	stat -t '%Y-%m-%d %H:%M:%S' -f '%SB%t%N%n' * | sort | awk '
		NR > 1 {printf("%s,", last) }
		{	last = $0 }
		END {	print last }'
}

if your shell allows hyphen characters in function names (which is not portable and is not required by the standards) and your system has a BSD based version of the stat utility.

Unfortunately, the stat utility is not specified by the standards either so methods used to print a file's creation time (if the file system the files reside on keeps a file's creation time [which is not required by the standards]) varies from system to system and the methods used to specify strftime()-like format strings for printing dates varies from system to system (with some systems not providing creation dates nor any way to get the date/time format you want).

If nothing else, maybe the above code will show you how to use awk to convert a sorted text file into a single line output with input lines separated by commas instead of <newline>s.

This was tested on macOS Mojave version 10.14.3 with a BSD-based stat utility (probably with macOS extensions). Note that this version just sorts on the YYYY-mm-dd HH:MM:SS date/time stamps instead of trying to get a finer grained timestamp using UNIX Epoch times.

I have no idea what the stat utility man page on your system says about printing file creation dates or about ways to specify the format of dates that are to be printed.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

List files that are not directories from current directory

I can't manage to list all files that are not directories from current directory. (2 Replies)
Discussion started by: beni22sof
2 Replies

2. Shell Programming and Scripting

Finding files in current directory when 100,000's files in current directory

Hi All I was wondering what is the most efficient way to find files in the current directory(that may contain 100,000's files), that meets a certain specified file type and of a certain age. I have experimented with the find command in unix but it also searches all sub directories. I have... (2 Replies)
Discussion started by: kewong007
2 Replies

3. Shell Programming and Scripting

mget * (obtein files from current directory but not the files form sub-directories)

Hello, Using the instruction mget (within ftp) and with "Interactive mode off", I want to get all files from directory (DirAA), but not the files in sub-directories. The files names don't follow any defined rule, so they can be just letters without (.) period Directory structure example: ... (0 Replies)
Discussion started by: Peter321
0 Replies

4. Shell Programming and Scripting

List files in the current directory - BOURNE SHELL

i am trying to write a program, that will list .txt files and .png files. it will ask the user what type of files do they want to list! so if the user inputs txt files.. how would you list all the .txt files in the current directory (the directory the program is running)!! thanks (1 Reply)
Discussion started by: bshell_1214
1 Replies

5. Emergency UNIX and Linux Support

List matching directories in current folder only on AIX

Hi, I need to find the list of matching direcories in current folder only and no subfolders on AIX.I tried -maxdepth option but its not working. Also, tried ls -d option to list the matching directories but getting argument list too long... So, any help would be appreciated. (6 Replies)
Discussion started by: sachinkl
6 Replies

6. Shell Programming and Scripting

How to list all the files, directories and sub-directories in the current path except one directory?

Can anyone come up with a unix command that lists all the files, directories and sub-directories in the current directory except a folder called log.? Thank you in advance. (7 Replies)
Discussion started by: Manjunath B
7 Replies

7. Shell Programming and Scripting

Find specific files only in current directory...not sub directories AIX

Hi, I have to find specific files only in the current directory...not in the sub directories. But when I use Find command ... it searches all the files in the current directory as well as in the subdirectories. I am using AIX-UNIX machine.Please help.. I am using the below command. And i am... (2 Replies)
Discussion started by: aakishore
2 Replies

8. UNIX for Dummies Questions & Answers

List the directories, having given pattern in the directories name, sorted by creation date

It is for HP-Unix B.11.31. Requirement: 1. List the directories, having given pattern in the directories name, sorted by creation date. Example: Directories with name "pkg32*" or "pkg33*" 2. On the output of 1. list the directories by creation date as sort order, with creation date... (2 Replies)
Discussion started by: Siva SQL
2 Replies

9. UNIX for Advanced & Expert Users

Find all files in the current directory excluding hidden files and directories

Find all files in the current directory only excluding hidden directories and files. For the below command, though it's not deleting hidden files.. it is traversing through the hidden directories and listing normal which should be avoided. `find . \( ! -name ".*" -prune \) -mtime +${n_days}... (7 Replies)
Discussion started by: ksailesh1
7 Replies

10. Shell Programming and Scripting

Finding non-existing words in a list of files in a directory and its sub-directories

Hi All, I have a list of words (these are actually a list of database table names separated by comma). Now, I want to find only the non-existing list of words in the *.java files of current directory and/or its sub-directories. Sample list of words:... (8 Replies)
Discussion started by: Bhanu Dhulipudi
8 Replies

LEARN ABOUT DEBIAN

time::piece::mysql

Time::Piece::MySQL(3pm) 				User Contributed Perl Documentation				   Time::Piece::MySQL(3pm)

NAME

       Time::Piece::MySQL - Adds MySQL-specific methods to Time::Piece

SYNOPSIS

	 use Time::Piece::MySQL;

	 my $time = localtime;

	 print $time->mysql_datetime;
	 print $time->mysql_date;
	 print $time->mysql_time;

	 my $time = Time::Piece->from_mysql_datetime( $mysql_datetime );
	 my $time = Time::Piece->from_mysql_date( $mysql_date );
	 my $time = Time::Piece->from_mysql_timestamp( $mysql_timestamp );

DESCRIPTION

       Using this module instead of, or in addition to, "Time::Piece" adds a few MySQL-specific date-time methods to "Time::Piece" objects.

OBJECT METHODS

   mysql_date / mysql_time / mysql_datetime / mysql_timestamp
       Returns the date and/or time in a format suitable for use by MySQL.

CONSTRUCTORS

   from_mysql_date / from_mysql_datetime / from_mysql_timestamp
       Given a date, datetime, or timestamp value as returned from MySQL, these constructors return a new Time::Piece object.  If the value is
       NULL, they will retrun undef.

   CAVEAT
       "Time::Piece" itself only works with times in the Unix epoch, this module has the same limitation.  However, MySQL itself handles date and
       datetime columns from '1000-01-01' to '9999-12-31'.  Feeding in times outside of the Unix epoch to any of the constructors has
       unpredictable results.

       Also, MySQL doesn't validate dates (because your application should); it only checks that dates are in the right format.  So, your database
       might include dates like 2004-00-00 or 2001-02-31.  Passing invalid dates to any of the constructors is a bad idea: on my system the former
       type (with zeros) returns undef (previous version used to die) while the latter returns a date in the following month.

AUTHOR

       Original author: Dave Rolsky <autarch@urth.org>

       Current maintainer: Marty Pauley <marty+perl@kasei.com>

COPYRIGHT

       (c) 2002 Dave Rolsky

       (c) 2004 Marty Pauley

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Time::Piece

perl v5.12.4							    2008-06-07						   Time::Piece::MySQL(3pm)
All times are GMT -4. The time now is 09:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy