Choosing a column delimiter on uploading a table

  • Resolved w8tts

    (@w8tts)


    7 years, 7 months ago

    Due to the fact that I want to upload a CSV file that contains HTML and Google map data the use of a comma “,” or a semicolon “;” so I chose a pipe stem “|” to use as a delimiter. The first table I built with a small file worked fine. The second file I built with a little larger file didn’t work.

    I tried different types of uploads, like HTML, and those didn’t work for me.

    Is there a way to force WordPress to look for a specific delimiter or a list of delimiters in sequence? Or is there a better delimiter to use?

    Ted

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter w8tts

    (@w8tts)

    I just tried a tab character and that didn’t work.

    Thread Starter w8tts

    (@w8tts)

    Okay. I’m thinking that this is a problem with the data that I’m trying to upload. I just did two more tables, one small and one much larger. Now all I have to do is find the problem.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, this might be a different problem. Note that using ; or , should also be possible. You will just have to make sure that the cells that contain such a character in their content are properly escaped – which means that the cell content has to be wrapped in quotation marks ", like

    Cell 1,Cell 2, Cell 3
Cell 4,"Cell 5 has a , in it",Cell 6

    Regards,
    Tobias

    Thread Starter w8tts

    (@w8tts)

    Got it solved. Did some deep testing, by loading one row at a time into the table until it failed. Luckily it was the 12th row out of a 76-row table. And it turned out to be some HTML code in the data, Once the code was removed everything was fine.

    • This reply was modified 7 years, 7 months ago by w8tts.
    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    great! Nice find! Good to hear that it’s working now!

    Best wishes,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Choosing a column delimiter on uploading a table’ is closed to new replies.