How can we help you today?
Import last 4 digits of credit card number
2 CommentsSorted by Oldest First
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
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
Thank you! That is very useful.
Marie Stark
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!