M
Mr.D
Guest
I have a database with a field holding odds for horses in races. It is a text field, with entries such as '100-1' and '5-2'. I need to take the number before the dash and put it in a new field, and take the number after and put it in another. Also there are occurances of 'evs' for evens 1-1, I will have to extract two 1's for that. Any ideas how this can be coded in VB I would be very grateful.