Shell Programming and Scripting

Friends,
I have to write a shell script,the description is----

i Have to check the uniqueness of the numbers in a file.
A file is containing 200thousand tickets and a ticket have 15 numbers in asecending order.And there is a strip that is having 6 tickets that means 90 numbers.I have to write a shell script like this----- No two tickets are common in 200thousand tickets and no two numers are repeating in a strip.
I would appericiate your help.

If you want some more info i am pasting it here.
---------------------------------------------------
Each ticket strip will have six tickets.
A strip is a group of 6 tickets. Every possible number from 1 through to 90 will appear on each full strip.
Each ticket will have 9 columns, and 3 rows. Hence a ticket strip will effectively have 9 columns and 18 rows.
Column 1 will have numbers between 1-9, 2 will have 10-19, so on till 8th column having 70-79; the only exception is the last column (9th column) having 80-90.
In each row there will be only 5 columns generated, the other 4 will be blank.
If there are more than 1 value in a column within a ticket, then they should be in ascending order.

If anyone can help me in writing this script,i will appericiate his help.
If anyone can guide me then also it will be good.I am trying but never wrote any script till now.

Hello namishtiwari,
I suggest you take a look at Perl if you have it on your system.
It's very powerful for parsing lots of data like this.
Can you please paste a couple of lines from the source data file so
that we can get a picture of how it looks like. When you use the word "common", you mean that every ticket is unique right?

Here is the insert statement through which we are inserting data.

insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (100,1,'071400004200007480000021364450660000001623390000007784',1);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (101,1,'050000004055627100001028330000680087080000004959007988',2);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (102,1,'001522300054600000060000004156007090091926310000610000',3);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (103,1,'000000004652677685011329384700000000001700000057697886',4);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (104,1,'020020340000007581001825004351640000030027370000650083',5);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (105,1,'041100004553007200000024324800630082001200350058007389',6);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (106,2,'000022340057007685071027004800620000000000360059687789',1);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (107,2,'021221004600000090051500310050007100080024004700617800',2);
insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (108,2,'001300334553000084040026000056657500001800394900660086',3);

Rexf,
Let me know the Perl script for this also.I will try to run that script in a system that have perl.
My requirement is---
1 strip has all the 90 numbers,numbers should be unique.
FYI one strip contains all the numbers from 1 to 90.

You have to clarify which columns you want to compare with what?
If we examine the first line;

insert into Ticket (TicketID,TicketStripID,TicketData,SequenceNo) values (100,1,'071400004200007480000021364450660000001623390000007784',1);

There are 4 values;

a) 100
b) 1
c) 071400004200007480000021364450660000001623390000007784
d) 1

Define the range limit for a, b, c and d, and explain _how_ you want
them to be compared, wheter the only requirement is that they should be unique within specific ranges, and compared to each other, or other comparison requirements?

rexf thanks for your kind help.
That problem is solved now,i got a new one and pasted that as a new thread.I will require your help in that.
Thanks in advance.