External Source Team Names V Betfair Team Names

I was wondering if anyone had any ideas on how I might be able to fix this problem.

I currently have a trigger that reads selections from a text file from another source.

My problem is the external source occasionally names the teams different from Betfair for example tonigt:

The source names the teams "Ankaragucu v Gaziantep" but Betfair names them "Ankaragucu v Gaziantep FK"

The trigger only fires if the names are exactly as per Betfair.

Aside from trying to get the source to change their naming convention, does anyone have any ideas how I might be able to solve this?

Thanks

Hi
Try fuzzy search which will do approximate string matching for up to three characters. To activate fuzzy search put an asterisk at the start of each line in the text file.

Thanks Mark.

Would it be:

“*team A v team B”

Or

“*team A v *team B”

It's:

*"team A v team B"

like you use at the moment but put the asterisk first

Thanks Mark.

External Source Team Names V Betfair Team Names

Hello Guest