Gallery
Share
Explore

icon picker
Decimals - comma instead of a full stop

Conversion form USA format to EU format and the other way around.

How to turn the USA number into a EU Number?

the easiest answer you find in this answer from Bill. This goes very fast and is accurate.
⁠
Deterministic AI
Generative AI has a PR problem. The vast majority of ChatGPT users have been misled into thinking AI is often stupid, especially with regard to numbers. Indeed, generative AI cannot perform math with precision because it is designed to do only one thing - Predict the next word based on a collection of words, specifically tokens. When math is involved, it goes off the rails quickly. While the LLM knows about numbers like 22, zero, and 8 – it has no concept of zero, 8022, or 2208 because the...
community.coda.io
⁠
⁠

The complicated answer you find below. It is a complex puzzle I took on for the sake of puzzling. It has limited practical value. There is a simple solution as well, a bit lower.
⁠
Nbr Formatting
Name
input
decimalsAlternative
i
decimals
i
mainNumber
theLength
i
leftPart
rightPart
i
output
backToUSAFomat
simpleSolution
1
Number 1
9,456,728,100
0
​
9456728100
10
1258
14710
9.456.728.100
9,456,728,100.00
94,567,281
2
Number 2
1002.10
0.1
10
1002
4
12
14
1.002,10
1,002.10
1,002.1
3
Number 3
32.51
0.51
51
32
2
131
2
32,51
32.51
32.51
4
Number 4
456,728,100
0
​
456728100
9
1147
0369
456.728.100
456,728,100.00
4,567,281
5
Number 5
48.4
0.4
4
48
2
131
2
48,4
48.40
48.4
6
Number 6
123,456,789.10
0.1
10
123456789
9
1147
0369
123.456.789,10
123,456,789.10
123,456,789.1
7
Number 7
1000
0
​
1000
4
12
14
1.000
1,000.00
1,000
8
Number 8
800
0
​
800
3
11
03
800
800.00
800
9
Number 9
10989383933
0
​
10989383933
11
1369
25811
10.989.383.933
10,989,383,933.00
10,989,383,933
There are no rows in this table
⁠


SwitchIf(thisRow.input.Find('.') >= 1,
thisRow.input.Slice( -(thisRow.input.Length() - thisRow.input.Find('.')))).WithName(decimals,

thisRow.input.Slice(1,thisRow.input.Find('.')).Split('').Filter(CurrentValue.IsNumber()).Join('').WithName(mainNumber,
mainNumber.Length().Remainder(3).WithName(start,
Sequence(start,mainNumber.Length(),by: 3).WithName(rightPart,
Listcombine(1,Sequence(1,rightPart.Count()-1).ForEach(rightPart.Nth(CurrentValue) +1)).WithName(leftPart,
Sequence(1,rightPart.Count()).ForEach(mainNumber.Slice(leftPart.Nth(CurrentValue),rightPart.Nth(CurrentValue))).Filter(CurrentValue.IsNumber()).Join(".").WithName(outcome,
SwitchIf(
decimals.IsBlank(),outcome,
decimals.IsNotBlank(),
Format("{1}{2}{3}",
If(mainNumber > 3,outcome,mainNumber),
Concatenate(","),
decimals),
Concatenate(mainNumber,",",decimals))

))))))

Simple Solution:

put column on number
select decimal separate in the settings
If(thisRow.input.ContainsText(","),
thisRow.input.Split('').Filter(CurrentValue.IsNumber()).Join('').WithName(base,
base.Splice(base.Length() -1,0,'.')),
thisRow.input)

Simple Solution 2:

With the introduction of SubsituteAll() the solution is rather straightforward. You move your EU numbers (comma instead of period to indicate decimals) to USA numbers with:
thisRow.theNumber.SubstituteAll(".","").Substitute(",",".")

Name
theNumber
substitute
substituteAll
solution
1
Number 1
1.000.000.000,00
1000.000.000,00
1000000000,00
1,000,000,000
2
Number 2
234.567.890,12
234567.890,12
234567890,12
234,567,890.12
3
Number 3
876.543.210,34
876543.210,34
876543210,34
876,543,210.34
4
Number 4
456.789.123,45
456789.123,45
456789123,45
456,789,123.45
5
Number 5
123.456.789,56
123456.789,56
123456789,56
123,456,789.56
6
Number 6
987.654.321,67
987654.321,67
987654321,67
987,654,321.67
7
Number 7
654.321.987,78
654321.987,78
654321987,78
654,321,987.78
8
Number 8
321.987.654,89
321987.654,89
321987654,89
321,987,654.89
9
Number 9
789.123.456,90
789123.456,90
789123456,90
789,123,456.9
10
Number 10
567.890.123,01
567890.123,01
567890123,01
567,890,123.01
11
Number 11
345.678.912,23
345678.912,23
345678912,23
345,678,912.23
12
Number 12
912.345.678,34
912345.678,34
912345678,34
912,345,678.34
13
Number 13
678.912.345,45
678912.345,45
678912345,45
678,912,345.45
14
Number 14
432.109.876,56
432109.876,56
432109876,56
432,109,876.56
15
Number 15
210.987.654,67
210987.654,67
210987654,67
210,987,654.67
16
Number 16
109.876.543,78
109876.543,78
109876543,78
109,876,543.78
17
Number 17
543.210.987,89
543210.987,89
543210987,89
543,210,987.89
18
Number 18
768.543.210,90
768543.210,90
768543210,90
768,543,210.9
19
Number 19
890.123.456,01
890123.456,01
890123456,01
890,123,456.01
20
Number 20
102.345.678,12
102345.678,12
102345678,12
102,345,678.12
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.