Comma in field

  • Resolved laperrej

    (@laperrej)


    7 years, 8 months ago

    Hi,
    How can I import csv files that have fields with comma’s in them. I tried:
    – enclosing those fields in quotes ” ”
    – enclosing all fields in quotes (regardless of whether or not they have comma’s in them)
    – escaping the comma with \

    None of these approaches work. Please advise. Thanks in advance.

    Kind regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support mbrsolution

    (@mbrsolution)

    Hi, just for testing purposes can you try to import a CSV file without any commas in the fields. What happens then?

    Thread Starter laperrej

    (@laperrej)

    It works fine without commas in any field.

    With commas, the number of columns displayed is incorrect, and the upload fails too. Doesn’t seem like this is supported.

    Plugin Support mbrsolution

    (@mbrsolution)

    Hi, thank you for reporting back. The plugin developers will investigate further your issue.

    Kind regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Comma in field’ is closed to new replies.