How to convert a value to decimal separator

Help Activities
, ,
1

Hi,
I have a value as string and need to separate by decimal separator

1558034 to 1.558,034
or
11558034 to 11.558,034

Thanks

2

when this number 1558034 should be a number with decimal part, then you need at least a reliable rule for placing the fraction part divider.

Also it is recommended which local numberformat is to apply

3

in Excel file it has 1,558,034 after reading the file inside for each loop in write line it write as 1558034, I need to write is as 1.558,034 in SAP

4

How should we determine where the . goes? In your first example it’s after the first digit, but in your second example it’s after the second digit. What’s the logic here?

5

1,558,034 and 1.558,034 are not the same value.

6

in addition to your above edited samples

when it is about this criteria:
grafik

then we can reformat e.g. by
grafik

1 Like
7

The below post will helps you.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.