If therefore, why not post it as an connection to a Answer back, therefore that I can obtain a better experience for the comprehensive picture.I have ended up a informal and simple filemaker consumer for a quantity of years, beginning with the easy form that has been incorporated with ClarisWorks all those decades ago.I recently chose to challenge myself to create a database to help very easily decipher and report manufacturing codes for a hobby I are involved with - Vintage BMX Bikes.To state the minimum I possess stumped myself properly and really and was looking for some help.
Mongoose Bmx S Lookup Serial Quantity ButI know for certain the meaning of the series of the amounts and letters in the stamped serial quantity but I cant obtain my mind around transforming it to a data source. Is certainly 5th month (May), 1980, 1161st in sequence, welded by Darrell Kendall. There is physical evidence on the body of the design change so that can be designated in the data source. What I really need help to work out is definitely what will be the greatest way to become capable to kind in the quantity and character placed on the body and have it decoded. The above utilizes a duration of 99 to drive it to select everything to the finish of the framéNo from the 3rd character onwards. What Im not really very clear about is what they did in October, Nov or December, as there seems to become just a individual number for the month. Right after the sequence, solely for pictures benefit, the last Dec 1981 body, build series 256 welded by Mark Bradshaw bike would become stamped. When we only got a few structures as benchmark you could recognize our trouble in setting up their history. It will be known that there are usually two versions - the second commencing in September 1981 eg: 918D. Regrettably we sense there might become an overlap from edition one to version 2 of probably a month or so. Therefore in overview - the program code for the stamping stayed the exact same but was re-set with no additional acknowledgement. Right now you could possible possess an idea why I have got been ripping my hair out. If there are usually two versions of the frame number and each demands to be interpreted differently, then the edition should become came into into another field (supposing its not really apparent from the body number solely). Now I would suggest you sit down down with a item of document and write down the methods you would take to recognize the 30 days and the yr without a computer (think of this as composing instructions for a stupid but reliable person). Then the real calculation will become simple to construct - presuming the job is feasible in the initial place. If you have actually a rough idea of the sequences progress, after that some interpretations can be eliminated: for example, if you have got 62500, then 122900 MUST become December, and 12200 MUST become January. Ive become toying with your small sample data in TextWrangler, and I think it might be probable to perform the lions share of this parsing out making use of grep styles in TextWrangler or BBEdit. The real challenge can be the March - January productions, nevertheless, I had been able to parse out the December and Jan illustration you offered, making use of a few of greps. Are usually you attempting to breakout this data on bikes you own personal, bikes you want to buy, or are you doing this for aIl of the bikés manufactured by these two. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |