1 (edited by kbalmer 21-05-2014 15:48:59)

Topic: Import wizard observer name matching

I've just been provided with a dataset of 83,000 records and it contains a weird and wonderful selection of observer name formats. I'm astonished at how well the import wizard is coping with making sense of them, but the following are tripping it up:

De Winter, M
O'Dwyer, J
Oakley-Martin, D
Orr-Ewing, D C

It splits each of these on the comma into two separate observers, resulting in M, J, D and D C appearing in the grid of names to be matched.

Now that I've found the problem with these I can hopefully pre-process the data to reformat these into something that it can handle, but just in case someone fancies diving into what must be some very clever code at some point I thought I'd mention them. (Then again it may be better to leave the code alone in case the magic is broken).

Keith