However, the real test would be with real data. The real challenge is the Oct - Jan productions, however, I was able to parse out the Dec and Jan example you gave, using a couple of greps. I've been toying with your sample data in TextWrangler, and I think it might be possible to do the lion's share of this parsing out using grep patterns in TextWrangler or BBEdit. If you have even a rough idea of the sequence's progress, then some interpretations can be eliminated: for example, if you have "", then "" MUST be December, and "" MUST be January. A thought: if the date is ambiguous, couldn't you use the sequence to determine the correct choice? After all, an ambiguous date is either January or one of the last three months of the year. Then the actual calculation will become easy to construct - assuming the task is possible in the first place. Now I would suggest you sit down with a piece of paper and write down the steps you would take to identify the month and the year without a computer think of this as writing directions for a stupid but reliable person. If there are two "versions" of the frame number and each needs to be interpreted differently, then the version should be entered into another field assuming it's not apparent from the frame number alone. So we also know that the first edition frames were stamped in the same way but from we think September the build sequence was reset to "1".
#Specialized serial number search code#
So in summary - the code for the stamping remained the same but was re-set with no additional acknowledgement. Unfortunately we feel there might be an overlap from version one to version 2 of maybe a month or so. Brian's remark is right on the money: how can you tell that "M" is not Januaryor that "D" is not December57? When we only had a few frames as reference you could understand our difficulty in establishing their heritage. From what we can tell there were 3 welders all identified by a single letter - their first initial.įollowing the sequence, purely for illustrations sake, the last December frame, build sequence welded by Mark Bradshaw bike would be stamped.
#Specialized serial number search crack#
We think all bikes are manufactured in the eighties - you would not believe how hard it was to crack this code - the bikes made in the seventies have totally different serials - which still haven't been deciphered yet.
![specialized serial number search specialized serial number search](https://bikeindex.org/assets/serials/serial_pinsch-6f3f7649e47357b71418d60d536e1582c12c8a6c9ef4bfefd35c7422495c5e59.jpg)
What I'm not clear about is what they did in October, November or December, as there appears to be only a single digit for the month. What I really need help to work out is what is the best way to be able to type in the number and character stamped on the frame and have it decoded? From the two frame numbers you have offered, you could use a few calculated fields to get the information out that you need viz. There is physical evidence on the frame of the model change so that can be marked in the database. I know for certain the meaning of the sequence of the numbers and letters in the stamped serial number but I can't get my head around transforming it to a database! I recently decided to challenge myself to write a database to help easily decipher and record manufacturing codes for a hobby I am involved with - Vintage BMX Bikes. I have been a casual and basic filemaker user for a number of years, starting with the simple form that was included with ClarisWorks all those years ago.