I need to know how to write the Regular Expression(s) and Value(s) for a dictionary to pick up numeric and alpha numeric ID numbers in the following format types:

NN-A, NNN-A, NNNN-A, NNNNN-A, NNNNNN-A

NN, NNN, NNNN, NNNNN, NNNNNN

Where N is an integer from 1 through 9 to 0. None of the ID numbers may start with zero.

The data are from 'giving sites', that is donations from websites such as JustGiving and MuchLoved.

The purpose of the dictionary is to allow for automatic tributing using excel CSV reports (spreadsheets) as vehicles for import data. The ID numbers are the tribute IDs.

This may require two Reg ex instead of one.

I attach two dictionary examples based on surname and first name. How different would numerical/alpha-numeric expressions need to be?

(My initial thinking was to use the tribute name. However, I now feel that this is not sufficiently unique, whereas the tribute ID is very much unique and that is what we must use.)

Thank you in advance.

Problem solved with \d|[1-9]\d{5}