Shell Programming and Scripting

Hi

I want to select older file if multiple files exist with same name.
eg:There are five files in UNIX folderHowever in file list i.e FileName.DAT I have data likeI am using FileName.DAT to read content of FileNames.

If multiple files exist as in this case Sample1 , I want to select older one , i.e. Sample1_20091231

So in this case I want to select Sample1_20091231,Sample2_20100115,Sample3_20100115 and neglect
Sample1_20100110,Sample1_20100115.

How to implement it ?

Any Suggestions.

Code:

$ ls Sam* |sort |awk -F "_" '!a[$1]++ {print $0}'
Sample1_20091231
Sample2_20100115
Sample3_20100115

Thanks Dost

That one-liner worked gr8 for me

KUDOS !!!

UNIX FORUMS ROCK!!!

---------- Post updated at 02:52 PM ---------- Previous update was at 11:34 AM ----------

Hi

I am using this code.

Code:

 
#!/bin/ksh
while read line
do
ls $line |sort |awk -F "_" '!a[$1]++ {print $0}'
done<filename.DAT>fileselected.DAT

However if $line has some value Say 'ABC*' and there no file exist as ABC* then it will prompt error, I want to save an entry for those files also by displaying $line.


eg: Content in filename.DATFiles in folder are :Using the above code I am getting :But there is no entry for ABC1.

Output required isHelp me with this !!!

Maybe something like this?

Code:

#!/bin/ksh

while read line
do
  ls $line* > /dev/null 2>&1
  if [ $? -ne 0 ]; then
    echo "$line"
  else
    ls $line* |sort |awk -F "_" '!a[$1]++ {print $0}'
  fi
done < filename.DAT > fileselected.DAT

Thanks MITRA

UNIX FORUMS ROCKKKK

Another alternative:

Code:

while read f; do
   set "$f"*
   [ -e "$1" ] && f=$1
   echo "$f"
done < filename.DAT > fileselected.DAT

Read a line from filename.DAT and use it as the basis for a glob. If there is a match, the shell expands the glob in the set command and replaces it with an already sorted list, which given the format of the filenames will place the oldest in $1. If there is no match, $1 will contain the unexpanded glob. We then check to see if $1 exists to decide what to echo.

Note: Simply comparing "$f"* to "$1" would probably work in this case, given the constrained filename format, but in general it could fail since it would be possible for there to be a file whose name is identical to the pattern it matches: f* could expand to match a file whose name is f*.

Regards,
Alister