Start a new topic

Reg ex & Values for ID numbers (Raiser's Edge)

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.


(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.

 

 

 

 

 

 

 

1 Comment

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

Login or Signup to post a comment