Horse 'N' Hound

[Michal]

Hi,

Yesterday I didnt place a bet because my horse did not match the Betfair name. I am aware that appostrophies are not being used in Betfair and I strip mine from my names however this horse was left unbet which meant that the name in the market was not the same unfortunately I was not at home to see this and couldnt load the race back into BA to check and was wondering if anyone might have any thoughts on that.
I had Horse N Hound.

Thanks

Michal

[phrenetic]

I haven't looked at this in detail, but I would strip out all apostrophes and spaces, convert everything to lowercase and then do a comparison.

Alistair

[Michal]

Hi Thanks for that I actually already convert to propercase but that one seams to slip through I report next time it runs ........
the rest of the formating works ok as I have it

[Ian]

There have been two horses recently which have appeared to have had an unusual character in the name when put into Excel via BA.

[Michal]

Hi,

I got the solution to this when the horse has a name with 'N' the conversion is "n" so my
Horse 'N' Hound becomes
Horse n Hound

I base this on the spelling of another horse from the other day that had the same 'N' in its name and the corresponidg change was applied.

Michal

[Mitch]

If you put

Code: Select all

Option Compare Text

at the top of your vba code it will ignore case for comparison purposes.