We are using ImportOMatic for Raisers Edge.

I need 2 values in my dictionary.

ACTUAL DATA IMPORT VALUES:  

I need the following VALUES to be written to the database:

What Regular expression would I use to achieve this?

Thanks

Thank you!

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:

• 1 Corporate Table Sponsor
• 2 Corporate Table Sponsor
• 26 Corporate Table Sponsor
• 45345645 Corporate Table Sponsor

It won't match

• Corporate Table Sponsor (doesn't start with any numbers)
• 1,200 Corporate Table Sponsor (the comma isn't a number)
• 2 Corporate Table Sponsors (there's an extra "s" at the end)

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.

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

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.

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