Visokio website     Downloads     Video tutorials     KnowledgeBase  
Data preparation: CSV cell separator - more than 1 character - Visokio Forums
Data preparation: CSV cell separator - more than 1 character
  • VoteVote Up1Vote Down JamesPC July 18, 2017 12:38PM
    in CSV most common separator is the comma but sometimes other data contains a comma which I know the workaround is quotes but if it was a random thing like:
    ;%#£
    then the likelihood of this appearing in the data is substantially smaller than a "," appearing.
  • 1 Comment
  •     paola July 19, 2017 7:16AM
    We will see if there is interest to add this feature.
    In the meantime, if you have combination of characters that you would like to use as a separator, you could use Search/replace block to replace ;%#£ with a character that doesn't appear in your data, then use it as a separator.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged