How to import data with comma into a single column

Dear All

Would you please advise?

I have received the feedback from Board vendor that Board BI can not import data with comma into a single column.

It seems that it is the technical constraint from Board technology.

Let me explain more and give you the case we face as the following :

We are using the Board BI version 10.1.3 and We have extracted data from SAP with CSV data file where values may have comma as part of value. Our column separated delimiter is set "|" as pipe delimiter.

for example

We import this 10,000 value from CSV data file into Board BI

It seems Board BI recognizes that data which contain comma value, it is separated by comma automatically So data is presented as 10 instead of 10,000.

We are not sure Is this the technical constraint ?

Find more posts tagged with

Accepted answers

All comments

Daniele Di Lorenzo

Check data reader settings

if the file is a csv "|" delimited you have to set the correct separator in the ascii data reader setup and the nr 10,000 will be correctly recognized.

Also be sure that the server settings are consistent, with the comma set as decimal separator.

Chonpat Laymanuman

Hello

Thanks a lot for you advise, I have asked our vendor to try your solution but it does not work properly.

Let's see attached picture and kindly further advise

Daniele Di Lorenzo

Which is the default dec separator in server settings where Board is installed?

Chonpat Laymanuman

please see our step above : we have set "|" as defaults separator in regional setting in our server.

It seems it does not work, we are not sure what step we are missing , please advise.

Daniele Di Lorenzo

sorry, maybe I was not clear

you have to check the decimal separator setting

if comma is ok, figures should be uploaded correctly

if dot it's normal that when you read a file with comma as separator it's not recognized