Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Asif Malik 203 posts 339 karma points
    Dec 08, 2011 @ 17:49
    Asif Malik
    0

    Alternative field separator

    Hi Richard, I have  aCSV file which is pipe (|) separated. How do i go about adding to the list of field separators ?

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Dec 09, 2011 @ 08:49
    Richard Soeteman
    0

    Hi Asif,

    Great question, Currently it is only possible to have the , and ; as seperators. I will create an option, or config where you can specify your own characters for a next release.

    Thanks,

    Richard

  • Johanna Dunn 6 posts 76 karma points
    Sep 04, 2015 @ 15:58
    Johanna Dunn
    0

    Hi Richard,

    I am using CMSImport to schedule a daily import of CSV file from a supplier. The only problem is that they use ^ as their field separator (and they won't change it). Is there any way that I can add this to the list of field separators, I've had a look in the config file and the manual but couldn't find any reference.

    The import works fine when I change the ^ to a standard separator but I'll have to do that manually each day rather than schedule it.

    Thanks Jo

  • Asif Malik 203 posts 339 karma points
    Dec 09, 2011 @ 09:42
    Asif Malik
    0

    Thanks, will re-export the data for now, look forward to the next release.

Please Sign in or register to post replies

Write your reply to:

Draft