Wrong delimiter detection

  • npeixoto

    (@npeixoto)


    9 years, 2 months ago

    Hello,

    First of all, thanks for you plugin, it really is helpful.

    I’m posting this topic to report the issue I went through when using your plugin with one of my CSV files :
    I’ve been trying to import the following file with your plugin :
    https://pastebin.com/vCBv3kBJ (select it, paste in excel, then save as ;-separated CSV file).

    But everytime I tried to do it, I had an error saying my file should at least have 2 columns (+ some PHP warning).

    After fiding out there’s an automatic delimiter detection, it all came clear to me : the wrong delimiter was detected.

    When you look at the file I hosted on pastebin, you can see there are way more commas than there are “;” and I think that’s where I’m getting this wrong delimiter detection problem.

    So, to solve my own case, I forced the delimiter to “;” in the PHP file and then put it back to normal after importing my file.

    As I said, this post is just to notify you that this issue exists, in case you’re interested in solving it !

    Good bye,

Viewing 1 replies (of 1 total)
  • Plugin Author Javier Carazo

    (@carazo)

    9 years, 2 months ago

    @npeixoto,

    And thanks for this message. Really this is a problem for us. Auto detect the delimiter is not easy.

    Maybe some option would be force the “delimiter” with some kind of list in the import, in this way we can solve it.

    What do you think about that?

Viewing 1 replies (of 1 total)

The topic ‘Wrong delimiter detection’ is closed to new replies.