CSV separator

  • Resolved mbalac

    (@mbalac)


    6 years, 11 months ago

    When exporting form entries to .csv the separator used is a comma, which is fine if no commas are used in inputs, but in case of a text field where commas are commonly used it creates issues by treating comma separated parts of sentence as separate cells.

    We’re using Multistep Form PLUS, and I don’t mean to be rude, but this is a major fail. May I recommend you use pipes | or semicolons ; ?

    What I’m interested in is replacing that comma with a pipe manually, how can I do that? Also, it would be great if my changes wouldn’t be overwritten with the next update, is such a thing possible.

    Thanks, and no offense.

    Milan

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi Milan,

    thanks for the feedback and sorry for the late reply! This is indeed a nasty issue.
    In the current implementation, we tried to avoid the issue by wrapping the entry columns in quotes (“one, two, three”). When using Tools like LibreOffice or MS Office, this technique provides a workaround.

    However, you are more that right when it comes to processing the csv programmatically or with other tools. We will be implementing a feature for choosing your own CSV separator right now. Am update will roll out tomorrow.

    Thanks for your patience and all the best,
    Lewe

    Plugin Author mondula2016

    (@mondula2016)

    Hi Milan,

    we just rolled out two updates and wanted to let you know that as of MSF 1.2.4 and MSFP 1.0.5, you are now able to choose your own CSV delimiter. We hope this resolves your issues.

    All the best,
    Mondula

    Thread Starter mbalac

    (@mbalac)

    Well, we already made the necessary changes in the plugin files so I won’t be updating any time soon ?? But I do appreciate a rather quick response. From what I can see you guys listen, and in this case it made the plugin better for everyone.

    Much love, much respect.
    Milan

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