How can we help you today?

Start a new topic
Discussions Raiser's Edge ImportOmatic

regular expressions help

I am trying to create a dictionary for credit cards. So far the data field shows M-XXXX1111(with the last four numbers will vary off the credit card number).  I would like this to translate to Mastercard, Visa if it's V-XXXX2222, or American Express if it's A-XXXX3333. Is there a regular expression for this?
3 CommentsSorted by Newest First
Great! Please let us know if you have any additional questions.
thank you. that worked out perfectly.
Hi Harriet,

Thanks for using the Import-O-Matic Forums.  You can try doing the following:

Replacement Value:  Visa 
Value to Match On:  V.*

This will insert the word Visa when the text is formatted like V-XXXX2222.  Please be sure to check the Use Regular Expressions checkbox at the bottom of the screen.  

image




You can use the same formula format for the other credit types that you have.  I hope you find this information helpful.  Please let us know if you have any additional questions.

Best,

Callie
Login or Signup to post a comment
More topics in ImportOmatic
See all 1184 topics
Help Desk Software by Freshdesk Support Desk