[FinOps]

I would like to create a saved search that provides the first 6 digits of a credit card number and the last 4 of the credit card number. Users that don’t have access to the full card number automatically get the last four. Is the a formula that I could use to get the first 6 to also show? I have tried the substring formula but I get an error. I assume that is because it is an encrypted field?
This is a cached copy. Click here to see the original post.

[markluu]

Hi FinOps,

you are correct as the credit card number is encrypted. The only way to have access to the card number would be to contact Netsuite Support. From what I remember, they will send you some documents that will require the approval. You will have the credit card number unencrypted, but I highly doubt it would be possible to make the 6 first digits display like you want. It would be either all displayed or just the last 4 digits as it is right now.

Hope this helps.

Mark

[FinOps]

I can get the full credit card number but wanted to create a saved search to pull only the first 6 digits via a substring formula but it results in an error even though i have access to the entire cc number.

[rnedelkow]

Something like this might work:

Field = Formula (Text)

Formula = SUBSTR({field id},0,6)

[Author]

Posts