What can I do - excel data?

[A[L]C]

Hi all,

I have a spreadsheet with a lot of raw data from an ANPR camera.

Now there is a lot of rubbish in it! For example, VES8CWJ, VS8CWJ, VSBCWJ within milliseconds of each other - this is obviously (to a human) the same reg being read wrongly.

How can I set like a mask to reduce this ie. must be LLNNLLL or LNNNLLL (L = letter N = number)

Also, how would I group similar number plates within say 30 seconds of each other to show only the 'best' read?

http://paulharman.fmguy.com/anprdata.xlsx

Many thanks

 

[A[L]C]

Ok well ive used vba with regular expressions to find the best hits. Unfortunately I cant find a really good regex for uk number plates. Custom plates make it so hard!

 

[rpstewart]

Is there anything you can do upstream? I'd be shouting at whoever provided the ANPR kit and telling them it's generating useless data for a start.

 

[A[L]C]

not really although we are looking at another system