How to extract the data bits from Payment Widget field?

  • Profile Image
    SunbridgeInstitute
    Asked 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.

  • Profile Image
    Kiran
    Answered 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.