What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to extract the data bits from Payment Widget field?

    Asked by SunbridgeInstitute on June 28, 2017 at 01:03 PM

    When my users pay online, their billing address comes through on the final spreadsheet like this:

    All of that information is combined together into one field, and it comes through onto my spreadsheet as being altogether in one cell.

    I need to be able to use this data in a mail merge, and I am trying to figure out how to extract each bit of data into separate columns without the descriptors, as follows:

    -Street column

    -City column

    -State/Region column

    -Zip/Postal column

    -Country column

    Since you probably have other users who have had similar need/problem, can you point me toward any resources or ideas for how to accomplish this, without having to copy and paste manually?

    Thank you so much for your help.

    Page URL:
    https://www.jotform.com/build/70375228846968

  • Profile Image
    JotForm Support

    Answered by Kiran on June 28, 2017 at 03:16 PM

    Unfortunately, there is no direct way to extract the payment information to separate columns. However, you may export the data to Excel and then separate the payment field data to separate columns by using Text to columns option

    Please refer to the thread below that can help you with achieving your requirement. 

    https://www.jotform.com/answers/290516-How-to-seperate-payment-product-data-into-seperate-excel-columns

    If you need any further assistance, please let us know. We will be happy to assist.