CSV not splitting

  • fuchur777

    (@fuchur777)


    7 years ago

    All search works.

    But the CSV file is not splitting into multiple columns. Nomather what I try in the shortcode.
    format / charset changes… doesnt help all is parsed into column 0

    format=”{tr}{td}{0}{/td}{td}{1}{/td}{td}{2}{/td}{td}{3}{/td}{td}{4}{/td}{td}{5}{/td}{td}{6}{/td}{td}{7}{/td}{td}{8}{/td}{td}{9}{/td}{td}{10}{/td}{td}{11}{/td}{td}{12}{/td}{td}{13}{/td}{/tr}

    Becomes

    650439,,,,,,,,,1,92%,1,90%,1,83%,,,,,,,,,Mar-17,Mar-17 <1> <2> <3> <4> <5> <6> <7> <8> <9> <10> <11> <12> <13>

    Does anyone have a sample file they know work out of the box as cross reference?

    Gr Frank

    • This topic was modified 7 years ago by fuchur777.
Viewing 1 replies (of 1 total)
  • Kevin Borling

    (@kevinborling)

    I was experiencing the same issue but I found the problem. The plugin is trying to split each value by ; instead of ,

    I was able to fix the issue by editing the plugin file hk-filter-and-search/hk-filter-and-search.php on line 200.

    Old Value: var line = data[i].split(";");
    New Value var line = data[i].split(",");

    This isn’t an ideal fix but it’s helpful if you need this immediately. I am hoping the plugin author can add an option to change from ; to , in the future. Hope this helps.

    Also, if you don’t want to edit the file, a .csv file with a ; separator should work.

Viewing 1 replies (of 1 total)
  • The topic ‘CSV not splitting’ is closed to new replies.