Otto,

Let me give a brief of what I know and then I will lead into some
assumptions of mine.

My data is for consumable products that have a shelf life. My company pays a
vendor to store our product. The vendor is geographically located in Atlanta,
Chicago, New York, Los Angeles, etc. When I get data from this vendor I go to
their website where the data is consolidated. So what I assume is happening
and some of the patters I am seeing is that the date data formats change when
the their is a change in Warehouses which leads me to believe that each
geographically located Warehouse inputs and uploads their data in different
formats. As you pointed out some of the data is just down right garbage data
like the 080211 stuff as that had to be a human error in someone on their end
mistypig it... But you are right that I am going to have to use some other
records in my data set to try and make logical patterns out of the date code
data. I think the big thing I will need to do is get the data parsed out to
the most logical pattern I can and then manually alter the outliers... I
guess that I can do is work the.csv file before I try and import it into
excel ... The other thing that is frustrating is that this vendor must make
lots of changes to their website titles as last month they had certain title
names and they had them in certain columns and now in December they made
changes... So as you can imagine it makes it even harder for me try and
standardize a process on my end... I will be working on this file some more
and if I do get stuck I am sure I will ask some more questions...