Data preparation: CSV cell separator - more than 1 character
-
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
-
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!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.