If you are collecting credit card information and exporting your form data, you may see that the last digit of the credit card number is replaced by a zero. This issue occurs when you pull report data from your Reports tab or the CSV attached on the Manage tab.

It does not happen if you are pulling from data directly from the application database via the API. 

All Adobe Sign reports are exported in the form of a comma-separated value (CSV) file.

Most people who open a CSV open it with Excel because that is what most systems default to, and that results in this problem with the last digit. Microsoft Excel opens a CSV file and enters all data into a General field type. It is the safest generic option as Excel cannot anticipate what the values in the CSV will be. Excel does two things when opening a CSV file:

  • All numbers that have more than 11 digits are displayed as scientific notation (for example, 1.23457E+11)
  • Excel stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes (per the technical standard IEEE 754).

Try these options to remedy this issue:

  1. Open your CSV in some other application that does not make the same assumptions as Excel.
  2. Open the CSV file in Excel by changing the extension to .txt first, then
    1. Open the .txt file in Excel, select Delimited, and click Next.
    2. Deselect other options, select Comma, and click Next.
    3. Select the columns with the credit card data and select Text as the Column Data Format. Click Finish.
  3. Separate your credit card input field into two fields, one field with 11–12 digits, and a second with four digits
  4. Force your credit card field to have dashes between the sets of numbers using field validation. If you add dashes, the General field type processes the data more like a text field, so no data is lost but has dashes in it.

Option 2 or 3 may be the best options for you. Option 3 also gives you the option to mask the first set of numbers and leaves the last four numbers visible, which is a common practice.

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy