We are using ImportOMatic for Raisers Edge.
I need 2 values in my dictionary.
ACTUAL DATA IMPORT VALUES:
|1 Corporate Table Sponsor|
|2 Individual Ticket|
I need the following VALUES to be written to the database:
What Regular expression would I use to achieve this?
Why do you need a regular expression for this instead of two specific dictionary entries?
Replacement Value = Table, Values to match on = 1 Corporate Table Sponsor
Replacement Value = Individual Ticket, Values to match on = 2 Individual Ticket
David is correct. This is just a straight text-replacement so you don't need to use RegEx at all. Add the replacement values (Table, Individual Ticket) in the left box. Select Table and then add 1 Corporate Table Sponsor in the right side box. Then select Individual Ticket on the left and add 2 Individual Ticket to the right side box. Test it and then add it to your import field mapping.
I just realized the numbers in front of the text DO CHANGE. So I would need a wild card of some sort for the beginning characters
Thank you. However, I just realized that the numbers in front of the text DO CHANGE. Therefore, I will need some sort of Wild Card for them.
In that case, you just need the regex expression for "any number of numbers at the start of the line", which is ^[0-9]+
Replacement Value = Table, Values to match on = ^[0-9]+ Corporate Table Sponsor$
Replacement Value = Individual Ticket, Values to match on = ^[0-9]+ Individual Ticket$
That will match values like:
It won't match