cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Data services converting decimal point into Comma while writing data

0 Kudos

Hi Experts,

I am trying to write/load decimal data type data into .csv files and Salesforce tables/api using data services 4.2 SP 10.

Data services converting the decimal field value from decimal point to comma resulting in following situation -

1. Target CSV File : Data is getting wrongly written. Ex: 1,234 instead of 1.234.

2. Target Salesforce table : Job is failing as Salesforce decimal/double field can't accept comma(,) in it.

We tried checking the locale codes from locale selector but nothing got resolved. snapshot of the current setting is also embedded below.

Could you please help by providing some guidance here.

Many Thanks!

Kkam

Accepted Solutions (0)

Answers (1)

Answers (1)

akhileshkiran
Contributor
0 Kudos

Hi Kamlesh Arya,

You can use the conversation functions like to_decimal and to_decimal_ext to convert the source data in to decimal format.

1.png

3.png

Regards,

Akhilesh Kiran N.

0 Kudos

Hi Akhilesh,

Thanks for your suggestion.

The problem is not about converting any value to decimal. The field values are already of decimal type, which Data services is implicitly converting to comma(,) while loading into Target causing failure and wrong data load.

It needs some configuration changes but where exactly is what I am looking for.

Thanks,

Kamlesh