Shell Programming and Scripting

lorcan,
That is working pretty fine.Thanks.

What about the other validations like

1. duplicacy.

I want to add one more validation that is-

The total numbers in a group of six tickets ie(6 rows) must be 90.

Thanks a lot for your help.

lorcan,
if i want to find the duplicate records in my input file,what we can do for that.

Thanks
Namish

Code:

sort your_file | uniq -d

You can just add these lines instead of the existing for loop in the script

Code:

sort $inpFile | uniq -d | sed "s/$/& : Duplicate/g"  >> $errFile
for line in $(cat $inpFile | sort | uniq )

Thanks lorcan,

Now 6 rows make a strip and i need to check that the total there are 90 numbers in a strip excluding 00.

Thanks
Namish

You can just create a variable and accumulate the count_fields in the script until it is the 6th line of the file. And check if that is equal to 90.

The code i put for this is--

for line in $(cat $inpFile | sort | uniq)
do
count_fields=$(echo $line | sed "s/00,*//g;s/,$//g" | wc -c)
stripcheck =$((stripcheck+count_fields))
if [[ $COUNT -eq 6 && $stripcheck -eq 270 ]]
then
echo "The strip has 90 numbers in it"
fi

lorcan,
i got these errors when i ran the script now.before it was working fine i can not understand what went wrong with this.

./script1[26]: /tmp/sortfile.txt: cannot create
./script1[27]: /tmp/sortfile.txt: cannot create
./script1[28]: /tmp/sortfile.txt: cannot create
./script1[31]: /tmp/sample1.txt: cannot create
./script1[32]: /tmp/sample2.txt: cannot create
./script1[31]: /tmp/sample1.txt: cannot create
./script1[32]: /tmp/sample2.txt: cannot create
./script1[26]: /tmp/sortfile.txt: cannot create
./script1[27]: /tmp/sortfile.txt: cannot create
./script1[28]: /tmp/sortfile.txt: cannot create
./script1[31]: /tmp/sample1.txt: cannot create
./script1[32]: /tmp/sample2.txt: cannot create
./script1[31]: /tmp/sample1.txt: cannot create
./script1[32]: /tmp/sample2.txt: cannot create
./script1[26]: /tmp/sortfile.txt: cannot create
./script1[27]: /tmp/sortfile.txt: cannot create
./script1[28]: /tmp/sortfile.txt: cannot create
this is in a loop continously.

The inputfile i used is
00,11,21,00,00,55,00,73,83,07,00,22,39,43,00,66,00,00,00,15,00,00,44,58,67,00,87
52,14,24,30,00,00,00,70,00,00,00,00,32,47,50,60,74,00,04,16,27,38,00,00,00,00,89
56,10,00,36,40,00,00,00,80,00,12,25,00,00,51,62,72,00,09,00,00,37,49,00,69,00,84,07
00,10,23,33,00,00,63,00,82,02,00,00,34,40,59,00,77,00,06,16,24,00,00,00,66,00,84
00,14,00,30,43,53,00,73,00,04,00,27,00,48,00,67,00,83,00,19,00,35,00,54,00,74,87
08,00,21,00,44,00,65,72,00,09,17,22,32,00,00,00,00,81,00,00,00,37,46,58,68,76,00,87,65,85
00,12,25,00,00,50,61,00,85,01,15,00,31,00,00,00,79,88,00,00,29,00,41,52,62,00,90
00,00,21,34,00,51,61,00,83,08,18,00,00,43,00,00,78,88,00,00,26,36,00,59,62,79,00
88,12,00,38,42,00,00,00,85,00,13,23,00,00,52,60,74,00,06,00,00,39,44,00,67,00,87,86
03,00,00,00,41,56,00,73,84,04,17,22,32,00,00,00,76,00,00,19,29,00,49,00,64,00,86
77,00,00,30,40,57,00,75,00,00,00,25,37,00,58,68,00,81,00,16,00,00,46,00,69,77,89,12
03,00,24,34,00,50,00,79,00,00,16,00,00,46,54,62,00,90,07,00,28,38,49,00,68,00,00,54
00,12,00,35,00,55,00,70,82,00,13,23,00,48,00,60,00,87,08,00,00,00,00,58,66,71,88
07,00,23,00,46,00,62,00,83,00,10,00,34,47,00,66,72,00,09,13,29,00,00,52,00,00,90,09
00,00,00,31,44,50,67,73,00,04,19,22,32,00,00,00,00,86,06,00,00,00,48,59,69,76,00
11,00,20,30,00,00,65,79,00,03,00,21,00,46,51,00,00,85,07,17,00,33,47,00,00,00,87,87,00
00,14,00,31,00,57,63,70,00,04,00,24,00,45,59,00,00,90,00,15,25,35,00,00,66,71,00
00,12,23,00,48,50,00,00,84,08,00,00,36,00,00,60,73,88,00,16,00,37,49,52,00,75,00
05,00,22,00,00,55,64,00,80,06,11,26,00,41,00,00,72,00,00,13,00,32,00,00,67,78,83
66,11,00,34,41,00,63,00,00,07,00,29,00,00,57,00,72,81,00,15,00,00,49,58,68,76,00,87

I only added these two lines in the code which u suggested.
#for line in $(cat $inpFile)
sort $inpFile | uniq -d | sed "s/$/& : Duplicate/g" >> $errFile
for line in $(cat $inpFile | sort | uniq)
instead of for loop.


Please suggest me something.I am stuck.

Thanks