Categories
- All Categories
- 105 Oracle Analytics News
- 10 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.4K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 59 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Error when importing CSV files separated by semicolon and decimal separator colon

Summary
Error when importing CSV files separated by semicolon and decimal separator colon
Content
A customer is getting data from an external provider in the following format:
- CSV file with semicolon as column-delimiter and comma as decimal separator
Issue description:
1. When importing as new data set within DV the column-delimiter will be recognized correctly.
2. But the import fails to recognize the comma as decimal separator. Therefore this column will be treated as “attribute” and text field.
3. Changing the properties later does not help. I can change to “measure”, “number” and set aggregation to “sum”.
4. But the result will be that all decimal places will be lost and replaced by zeros (e.g. 156,34 will be replaced by 156,00). Or it may happen that the column remains empty.
Questions:
- Any ideas how to solve this issue (apart from modifying the CSV file)?
- The issue would not appear if we would be able to specify not only the column-delimiter (this is possible) but also the decimal separator. Is this on the roadmap?
Version
DV Desktop 12.2.5.1.0
Answers
-
probably need to preprocess that column, can use unix sed for example
0