Parsing comma delimited text file

chengwei · #1 (**permalink**) 02-23-2007

I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days.

The format is like this:
dirA,5
dirB,7

How do I write script to iteratively parse this text file & delete the files in the directories base on the number of days?

Any help to get started is appreciated!

matrixmadhan · #2 (**permalink**) 02-23-2007

not tested though!

Code:

awk -F"," '{ print $1, $2}' file | while read dir days
do
  find $dir -maxdepth 1 -type f -mtime +$days -name '*.*' -print | xargs rm -f
done

anbu23 · #3 (**permalink**) 02-23-2007

Code:

IFS=","
while read dir days
do
 if [[ $days -ge 7 ]]
 then
   echo $dir # rm -r $dir
 fi
done<file

matrixmadhan · #4 (**permalink**) 02-23-2007

Quote:

Originally Posted by anbu23

Code:

IFS=","
while read dir days
do
 if [[ $days -ge 7 ]]
 then
   echo $dir # rm -r $dir
 fi
done<file

Quote:

# rm -r $dir

I believe this would delete all the files and inclusive of subdirectories if there are any

and OP had requested only for deletion of files ( If am not wrong

)

And moreover what about the case when days is less than 7 ?

anbu23 · #5 (**permalink**) 02-23-2007

Quote:

Originally Posted by matrixmadhan

I believe this would delete all the files and inclusive of subdirectories if there are any

and OP had requested only for deletion of files ( If am not wrong

)

And moreover what about the case when days is less than 7 ?

You are right.It will all the files and its sub directories.

Just for example i am checking whether days is greater than 7.

chengwei · #6 (**permalink**) 02-23-2007

Thanks both for the speedy replies. It certainly helped me get started!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How do you delete multiple text from a comma delimited file	dolo21taf	Shell Programming and Scripting	1	02-20-2008 05:12 AM
Combining information from a comma delimited file	vzismann	UNIX for Dummies Questions & Answers	1	08-06-2007 06:20 PM
Loading a comma Delimited file into an Array	grandtheftander	UNIX for Dummies Questions & Answers	2	07-26-2006 01:19 PM
Converting Tab delimited file to Comma delimited file in Unix	charan81	Shell Programming and Scripting	22	01-20-2006 09:24 AM
Comma Delimited file	dbrundrett	Shell Programming and Scripting	2	04-05-2004 10:50 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by