|
Post by milfredo on Jan 15, 2021 21:54:38 GMT -5
No. The race designation as I put forth in original post. I don't have a list of all the race classifications since there are about 45-50 tracks. G1 stands for Drade 1 stakes race. G2 is a Grade 2 Stakes And G3 is Grade 3 stakes. Then there are Claiming races which are clm designation. Not all races have the n1x or n2x or n3x. So no way I know of to figure out what race will be cause it is in a data filed. As you have seen there is no common length for all the races designation.
|
|
|
Post by milfredo on Jan 15, 2021 22:00:02 GMT -5
No there is no way of knowing what the race designation is going to be in the data field. There is no common length in the race designations. The only races with the G designation are G1, G2, G3 stakes races. The rest are clm, Alw and the like. And each race dollar value is not constant either.
|
|
|
Post by Chris Iverson on Jan 15, 2021 22:05:57 GMT -5
Is there a finite set of all possible race designations that can be built or referenced?
If it's not G1-3, do the designations have a fixed size, or are letters only, or something?
I've noticed that, besides the G1-G3 ones, all of the examples you've given have been three letters. Is that always consistent?
There must be some logic we can duplicate, because presumably there are other things consuming this data successfully. How are other things doing it?
|
|
|
Post by Carl Gundel on Jan 16, 2021 10:38:32 GMT -5
Is there a finite set of all possible race designations that can be built or referenced? If it's not G1-3, do the designations have a fixed size, or are letters only, or something? I've noticed that, besides the G1-G3 ones, all of the examples you've given have been three letters. Is that always consistent? There must be some logic we can duplicate, because presumably there are other things consuming this data successfully. How are other things doing it? If the spec for the data is inconsistent then there is no way to write a program to parse it. Conversely if a program to parse it can be written then it can also be written in Liberty BASIC.
|
|
|
Post by gidiom2 on Jan 16, 2021 11:04:58 GMT -5
I'm probably stating the obvious but there must exist a lookup table for all the race designations which other (commercial?) software uses. Can the OP indicate where the datafiles are sourced from?
|
|
|
Post by milfredo on Jan 17, 2021 5:36:42 GMT -5
I must apologize for being a meathead. I found this data field. How I missed it I don't know. But here is an example.
9 Race Type CHARACTER XX 2 G1- Grade I stk/hcp
So based on this, I believe the following maybe the way to do this. Create a select case statement with all the data field 9 possibilities. Then based on the match parse everything after the first two characters of the race classification and use Val( xxxxxx) to get the dollar figure?
Haven't felt good for quite a while and still trying to code is reason I just didn't notice this. not thinking straight.
Thank you all for helping. I truly appreciate it.
Milfredo
|
|
|
Post by gidiom2 on Jan 17, 2021 6:43:02 GMT -5
Hope solution is clear now. Don't think anyone expects any apologies!
|
|