Shell Programming and Scripting

Dear all

i am having file with max 24 entries. i want to find which sequence is missing

file is like this

Code:

df00231587.dat
df01231587.dat
df03231587.dat
df05231587.dat
.
.
.
df23231587.dat

the changing seq is 00-23,so i would like to find out which seq is missing like in above file seq 02 and 04 is missing

so the output shoould be like this

Code:

02231587
04231587

is missing and leading zero is important.

thanks in advance

Moderator's Comments:

Please use CODE tags (not QUOTE tags) when displaying sample input, output, and code segments.

Hello sagar_1986,
I have a few to questions pose in response first:-Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, especially if there are only a few lines (and therefore IO is not so much of a worry) Giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.


We're all here to learn and getting the relevant information will help us all.



Regards,
Robin

Hello rbatte1,

its a shell script,actually i am giving missing file status for approx 350 types.
But till now i was giving just count and missing count for month,but now i want to give exact sequence for missing files.
Now i have tried to put all sequence in one file and comparing them output is driven but my requirement is without comparing (i.e. not in file) can we do it ??
i can get sequence i.e. 00-23 using cut command but my exact problem is how to get missing sequence and put them into desired format as stated above

Also there is one more problem i would like to discuss that,i am learning Unix and till date my biggest problem is transposing rows into column,i have already posted that thread but till i didn't understand how to figure it out.

My output is like this

i want to transpose rows into column.Plz explain me how to figure it out.
Note :number of rows may vary Hence the transpose script first read how many rows and then convert it into columns

Thanks in advance

Code:

awk -F '.' 'NR == 1{t=substr($1,5); a=00}
  {b=substr($1, 3, 2); for(i=a+1; i<b+0; i++)
    printf "%02d%d\n", i, t; a=b}
  END {for(i=a+1; i<=23; i++) printf "%02d%d\n", i, t}' file

Dear SriniShoo,

Thanks for the reply,it works fine for me,but will u plz elaborate the step by step functionality of code so that i can rewrite the code again as per my requirement

In the code
1. I am extracting the 3rd and 4th character
2. Since the list is incremental, I am checking current number is +1 of the previous number
3. If not, I am printing all the numbers between previous and current number

Other way to accomplish the task...

Input file:

Code:

cat list.txt
df00231587.dat
df01231587.dat
df03231587.dat
df05231587.dat
df0631587.dat 
df0731587.dat 
df08231587.dat 
df09231587.dat 
df11231587.dat 
df10231587.dat 
df19231587.dat 
df18231587.dat 
df17231587.dat 
df16231587.dat

if u run the below script..

Code:

awk -F"." '{
b=substr($1,5);
a[NR]=substr($1,3,2);
n=NR;
}
END {
for(l=0;l<=23;l++)
{
s=sprintf("%02d",l);
for(i=1;i<=n;i++)
{
if(s != a[i])
{
c=c+1;
}
}
if(c==n)
{
print s b;
}
c=0;
}
}' list.txt

the output is..

Code:

02231587
04231587
12231587
13231587
14231587
15231587
20231587
21231587
22231587
23231587

---------- Post updated at 12:26 PM ---------- Previous update was at 12:25 PM ----------

the above are missing files from list.txt