Mixed delimiters in CSV file causing issues

  • Resolved MikeGetsLeads

    (@mikegetsleads)


    6 years, 8 months ago

    I submit a form without any issues and all the data is correct but when I download the CSV file there are mixed delimiters viz. commas and smicolons, which overwrites the data after the semicolons.

    The field that is causing the issue is a multi-choice filed with up to 5 options. All the data is in two fields with comma delimiters but the multi-choice options are in one box in the report with semicolon delimiters. These options are inserted in their own columns in the spreadsheet.

    Here is a link to the exported CSV file, https://www.dropbox.com/s/8riucsefcm04s29/Export%20%283%29.csv?dl=0

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author EDGARROJAS

    (@edgarrojas)

    Hello!

    Actually the plugin is configured to put the multiple choice options in one box delimiting each selected option with a semicolon. Do you want to place each selected option in a separate column? If so please let me know and i can give you a tweak to do this.

    Regards!

    Plugin Author EDGARROJAS

    (@edgarrojas)

    Ohh sorry, thinking more about that actually it is not possible to put each selected option in a different column. If you do that each row will have different number of columns, for example if one person select one option and another person select two the row of the second person will have one more column than the first person so that would mess up with the layout of the table.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Mixed delimiters in CSV file causing issues’ is closed to new replies.