The way to do this in the product today is with Data Enrichment. You can get to it from the System Properties dialog. When you add a new data enrichment, you get a box with three tabs. The first tab changes the options on the next two, so it is important that you select "string literal" and "string literal". This will work fine for your use case..
Next you need to put in the regex. I didn't have one handy for credit cards but not a hard one to come by.
This also allows you to test your regex.
Now you need to map the enrichment, on the destination tab.
Here I used Object, but you need to use whatever field you mapped the value into (maybe a custom type?).
You also select the device(s) that will use the enrichment here.
You should check the documentation on Data Enrichment, but basically it allows to you to modify a value of one field and replace that value or overwrite the value of another field.
Thank you Grant I will try it.
A CC regex is (Just hoping it will help someone else)
An easier way is to replace all
-by an empty string before proceeding.
Thanks to @Michael's comment, here's a regex that matches Visa, MasterCard, American Express, Diners Club, Discover, and JCB cards:
On data enrichment wizard, on Source tab there is no Regular Expression type ? I am using 9.1.3 20130214. Am I missing something here? I have looked at the documentation (I already used String Literal for Lookup type)
c. Enter the field type of the key column in the select query in the Lookup Type field.
Just in case there is a problem with my computer. I have tried with 2 different computers and 3 different browser result is the same
This is a 9.2 feature so you will need to be on a 9.2 version.