Title: CSV not splitting
Last modified: February 27, 2018

---

# CSV not splitting

 *  [fuchur777](https://wordpress.org/support/users/fuchur777/)
 * (@fuchur777)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/csv-not-splitting/)
 * 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 8 years, 3 months ago by [fuchur777](https://wordpress.org/support/users/fuchur777/).

Viewing 1 replies (of 1 total)

 *  [Kevin Borling](https://wordpress.org/support/users/kevinborling/)
 * (@kevinborling)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/csv-not-splitting/#post-10022322)
 * 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.
    -  This reply was modified 8 years, 3 months ago by [Kevin Borling](https://wordpress.org/support/users/kevinborling/).
    -  This reply was modified 8 years, 3 months ago by [Kevin Borling](https://wordpress.org/support/users/kevinborling/).

Viewing 1 replies (of 1 total)

The topic ‘CSV not splitting’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/hk-filter-and-search.svg)
 * [HTML filter and csv-file search](https://wordpress.org/plugins/hk-filter-and-search/)
 * [Support Threads](https://wordpress.org/support/plugin/hk-filter-and-search/)
 * [Active Topics](https://wordpress.org/support/plugin/hk-filter-and-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/hk-filter-and-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/hk-filter-and-search/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kevin Borling](https://wordpress.org/support/users/kevinborling/)
 * Last activity: [8 years, 3 months ago](https://wordpress.org/support/topic/csv-not-splitting/#post-10022322)
 * Status: not resolved