Bicycle Serial Number Database3/23/2021
If so, why not post it as an attachment to a Reply, so that I can get a better feel for the complete picture.
![]() ![]() Bicycle Database Serial Number But II know for certain the meaning of the sequence of the numbers and letters in the stamped serial number but I cant get my head around transforming it to a database.Is 5th month (May), 1980, 1161st in sequence, welded by Darrell Kendall. There is physical evidence on the frame of the model change so that can be marked in the database. 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. The above uses a length of 99 to force it to select everything to the end of the frameNo from the 3rd character onwards. What Im not clear about is what they did in October, November or December, as there appears to be only a single digit for the month. Following the sequence, purely for illustrations sake, the last December 1981 frame, build sequence 256 welded by Mark Bradshaw bike would be stamped. When we only had a few frames as reference you could understand our difficulty in establishing their heritage. It is known that there are two models - the second commencing in September 1981 eg: 918D. Unfortunately we feel there might be an overlap from version one to version 2 of maybe a month or so. So in summary - the code for the stamping remained the same but was re-set with no additional acknowledgement. So we also know that the first edition frames were stamped in the same way but from (we think) September 1981 the build sequence was reset to 1. Now you could possible have an idea why I have been tearing my hair out. 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 its not apparent from the frame number alone). 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). Then the actual calculation will become easy to construct - assuming the task is possible in the first place. If you have even a rough idea of the sequences progress, then some interpretations can be eliminated: for example, if you have 62500, then 122900 MUST be December, and 12200 MUST be January. Ive been toying with your sample data in TextWrangler, and I think it might be possible to do the lions share of this parsing out using grep patterns in TextWrangler or BBEdit. 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. Are you trying to breakout this data on bikes you own, bikes you want to purchase, or are you doing this for all of the bikes manufactured by these two.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |