[SOLVED] Print all files with an extension in all subdirectories to a CSV (BASH)

Issue

I'm writing a bash script that handles backup logs. I have month folders which contain subfolders and in those subfolders there are multiple files that have the extension ".ptx".

I want to grab every file ending with .ptx and print this out to a CSV file.

I'm not sure how to approach this as I have pretty limited knowledge but I think I need to use find like in this example.

This is where I was at for the month February:

if [ -d "/Volumes/NAS/01_PROJECTS/01_SHORTFORM/2024/02_FEB/" ]; then
  
cd /Volumes/NAS/01_PROJECTS/01_SHORTFORM/2024/02_FEB/

printf '%s\n' * > AUDIO_BACKUP_LOG_02_FEB.csv

mv AUDIO_BACKUP_LOG_02_FEB.csv /Volumes/NAS/04_ADMIN/06_BACKUP_LOGS/MONTHS/2024/

echo "Feb completed"

fi

I'm not quite sure how to combine printf and find and also look into all the subdirectories.

Solution

To get just the name of the file and strip the directory path you can try something like:

find . -type f -iname '*.ptx' -exec basename {} \; > AUDIO_BACKUP_LOG_01_JAN.csv

If you want to exclude by mask some files you can try something like:

find . -type f -iname '*.ptx' -exec basename {} \; |grep -v '.bak.' > AUDIO_BACKUP_LOG_01_JAN.csv

Answered By - Romeo Ninov

Answer Checked By - Dawn Plyler (WPSolving Volunteer)