Decimal Separator Dot vs Comma Detector
List decimal separator profiles compatible with all nonblank cells, allowing opposite-character thousands grouping; ambiguous values such as 1,234 keep both interpretations.
Description
Decimal points and thousands separators differ between export conventions.
Decimal points and thousands separators differ between export conventions. A token such as 1,234 is compatible with both a grouped integer and a decimal-comma fraction, so a sample may not determine one interpretation.1
List decimal separator profiles compatible with all nonblank cells, allowing opposite-character thousands grouping; ambiguous values such as 1,234 keep both interpretations.
When to use Decimal Separator Dot vs Comma Detector
Use this tool to list decimal separator profiles compatible with all nonblank cells, allowing opposite-character thousands grouping; ambiguous values such as 1,234 keep both interpretations.
Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.
How to use Decimal Separator Dot vs Comma Detector and understand its results
- Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.
- Enter values using the field table and calculation rules, then run the tool.
- Read decimalSeparators, ambiguous. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| values | Values | list of string; maximum length: 10000; minimum entries: 0; maximum entries: 10000 | Required |
Enter sample cell strings. Blank trimmed cells are ignored. The tool tests dot-decimal/comma-grouping and comma-decimal/dot-grouping profiles using the exact decimal parser, retaining every profile compatible with all nonblank cells. It returns separators in dot-then-comma order and ambiguous true unless exactly one survives. Signed tokens are supported, grouping must use groups of three, and a decimal mark must have digits on both sides.
compatible profile = every nonblank token parses with its decimal separator and opposite grouping character Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| decimalSeparators | Decimal separators | list of string |
| ambiguous | Ambiguous | boolean |
{
"input": {
"values": [
"1.234,50",
"25,75"
]
},
"output": {
"decimalSeparators": [
","
],
"ambiguous": false
}
}Limitations and assumptions
It does not parse currency or percent symbols, exponent notation or space-grouped numbers. Integer-only samples often leave both profiles possible. Tokens longer than the helper's 200-character decimal budget fail that profile rather than being interpreted as arbitrary-precision input without a limit.
Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Cell-string lists also have a combined text budget of 100,000 UTF-16 units per list. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors. A successfully returned false flag is an evaluated outcome; its meaning is explained above.
Alternative or Complementary methods
Use Currency Symbol Strip to Number: Remove at most one leading or trailing Unicode currency symbol and parse an exact decimal using explicit decimal and grouping separators; embedded symbols are rejected. For a complementary task, use Percent String to Numeric Value: Convert a decimal cell ending in percent to an exact decimal fraction, using a dot decimal separator and no grouping; one percent equals one hundredth.
References
-
Decimal Separator Dot vs Comma Detector — tool.io
Similar or alternative tools
- Currency Symbol Strip to Number
Remove at most one leading or trailing Unicode currency symbol and parse an exact decimal using explicit decimal and grouping separators; embedded symbols are rejected.
- Percent String to Numeric Value
Convert a decimal cell ending in percent to an exact decimal fraction, using a dot decimal separator and no grouping; one percent equals one hundredth.