Hah, no way you're going to get the ls command to output a 2-dimensional spreadsheet consisting of directory names as the heading and file names sorted by extension, then name, under each column. This was a fun challenge. My solution is probably way over-engineered, but here it is. You could save this in a script if you want or just paste it to the command line.
Code:
(
ridx=0
cidx=0
maxrows=0
maxcols=0
delim=","
declare -A table
while IFS='' read -r -d $'\0' file; do
subdirs[$cidx]="$file"
table[$cidx,0]="$file"
((cidx++))
done < <(find ./ -mindepth 1 -maxdepth 1 -type d -printf "%P\0" | sort -z)
maxcols=$cidx
for ((i=0; i<$maxcols; i++));
do
ridx=0
while IFS='' read -r -d $'\0' file; do
name[$ridx]="${file##*.}::$file"
((ridx++))
done < <(find "${subdirs[i]}" -mindepth 1 -maxdepth 1 -type f -printf "%P\0")
ridx=1
while IFS='' read -r -d $'\0' file; do
table[$i,$ridx]="${file#*::}"
((ridx++))
if [ $ridx -gt $maxrows ]
then
maxrows=$ridx
fi
done < <(printf '%s\0' "${name[@]}" | sort -z)
done
maxcomma=$((maxcols-1))
for ((j=0; j<$maxrows; j++));
do
line=""
for ((i=0; i<$maxcols; i++));
do
line="$line${table[$i,$j]}"
if [ $i -lt $maxcomma ]
then
line="$line$delim"
fi
done
echo "$line"
done
) > dummy.csv
Assumptions:
* The code will be run in the parent directory of the subdirectories you want to list.
* Only directory names from the parent directory will be used, not any regular files.
* Only regular files will be captured from the subdirectories, not any sub-subdirectories.
* The code will only go down one level. If you have files that are several levels deep, they will be ignored. If you want files from several levels, you can change the 2nd maxdepth value to something greater than 1.
* The output will be a comma delimited text file. You can change the delim value to something else if you want and change the output file from dummy.csv to something else.
In general, here's what it's doing:
* Capture the top-level directory names and sort them then save in an associative array
* For each top-level directory, capture the file names under it and sort them by extension first, then name and then save those in the same associative array
* Loop through the array that was built from the results and output a line for each row
Adv Reply
Originally Posted by sudodus
Bookmarks