96719672967396749781978297839784989198929893989499019902

09672967300009784000000

00000000000989499010

First row is the header.

each row has an identifier as well, but as i go thru the rows, what i should get the first occurance only.

the columns are varchar(4)

ie.

row 1: 9672

row 2: 9894

sry should of left data example.