Decimal separator issue in .dat file - OCC tool

[ashish25bp]

Hi Experts,

I am facing an issue while converting .dat file in OCC tool.

I have UTF 8 unicode .txt file which we usually convert in OCC tool to prepare .dat file.

This file has several property values for example:

• Acute Oral toxity value 1.67mg/kg (decimal separator as dot)
• Acute Dermal Toxity value 2,700mg/kg (decimal separator as coma)

My settings in OCC tool for DN is " . " (dot)

Now when the .dat file is generated it converts 2,700mg/kg as 2.700mg/kg . It should have not converted to "dot" I assume and should remain "coma" only.

Where as the 1.67mg/kg remains unchanged.

Since this is done in offline mode the SAP user profile my not be impacting.

Can anyone please suggest on this.

Thanks In advance

Ashish

[christoph_bergemann · Accepted solution]

Hello Ashish

the handling of "floating point" data in combination with "UOM" is not easy. We have on the top to consider the settings in "Sap Gui".

Let us start with basics... and then ceck options.

a.) floating point data with UOM is save in "one format" only in the data base

b.) The "look and feel" of such data is steered by user settings in SAP Gui (so for some user the "comma" should show as a "dot" and vice versa

c.) I believe you could try this

1.) seperate the data in your "OCC Load" file. The "Dot" data in one file and the "comma" data in a different one

Check then you settings in SAP Gui.

If you would like to load "dot" data: the SAP Gui settings should fit; if you would like to load "comma" data: the same

I would assume the "online OCC" mode can then do a "proper" load..

Yes it is a a "two step" process... but you shoul try it

C.B.