Date+Number Autocolumn Classifier
Strict observed ISO date/canonical decimal column classifier; no locale guesses, spreadsheet coercion or identifier inference.
Description
Date+Number Autocolumn Classifier: return cell kinds, column kind.
A column can contain empty cells, numbers, dates or a mixture. A conservative textual classifier should specify exactly which formats it recognizes.
This tool returns cell kinds, column kind. Use the stated units and model convention when interpreting these fields.
When to use this tool
Use this tool when the supplied inputs match the specific operation described above and you need a repeatable result under its stated convention.
- Check the supported input and output contract against an existing calculation or observation.
- Use the complete example to confirm units, selector spelling and result interpretation.
How to use the tool and how it works
- Enter every field in the input table using the stated units and the exact supported selector spelling where applicable.
- Run the tool. Correct input errors before interpreting an output.
- Read the result fields below; use accompanying flags and the stated sign, boundary or model convention when interpreting a number.
Treat only an empty string as empty; accept the supported finite decimal syntax as number and valid YYYY-MM-DD Gregorian dates as iso-date. Ignore empty cells when deciding whether the column is homogeneous or mixed.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| cells | Cells. | List of text values |
| Output field | Interpretation |
|---|---|
| result | Object containing the following named result fields. |
| result.cellKinds | Cell kinds list, in the ordering described in the calculation. |
| result.columnKind | Column kind; use the stated units and sign convention. |
{
"input": {
"cells": [
"2026-01-01",
"2",
""
]
},
"output": {
"result": {
"cellKinds": [
"iso-date",
"number",
"empty"
],
"columnKind": "mixed"
}
}
}Limitations and assumptions
- Scientific notation, surrounding spaces, localized numbers and alternative date formats remain text. Cells are supplied separately, not parsed from CSV here.
- Every declared field is required and unexpected fields are rejected. Numeric inputs must be finite; input errors are distinct from a valid false result or an explicitly qualified output.
- Extremely large inputs and nonfinite or excessively large outputs are rejected. List positions reported by the tool use zero-based indices unless stated otherwise.
Alternative or Complementary methods
Check the underlying observations, units and conventions independently before using the result in a larger workflow. The tools listed below address nearby tasks; compare their inputs and scope before substituting one for this operation.
References
Similar or alternative tools
- currency symbol strip to number
Currency cells combine a numeric amount with presentation symbols and locale-dependent separators.
- date format detection from column sample
A date such as 03/04/2026 can mean March 4 or 3 April.