Start a new topic

Import last 4 digits of credit card number

We are importing a file that contains credit card numbers in the following format: 1234********1111 I am wondering possible to set up a dictionary to import only the last 4 digits? We are currently editing the file in excel.  Has anyone used a regular expression for something like this?

Thanks!

 


Thank you! That is very useful.
Hi Marie,

You can set this dictionary up:

Replacement Value: -BLANK-
Value to Match On: ^.*?(?=\d{4}$)

To get the -BLANK- entry, hit the + button for replacement value.

Please let me know if you have any questions.

Thank you,
Amanda
Omatic Support
Login or Signup to post a comment