Scientific-Notation Gene-Name Date Guard
Flag legacy MARCH#, MARC1/2, SEPT#, or DEC1 symbols and ASCII scientific-notation-shaped cells as spreadsheet import risks; the rule is a heuristic, not a gene registry lookup.
Description
Spreadsheet imports can reinterpret identifiers as dates or scientific notation.
Spreadsheet imports can reinterpret identifiers as dates or scientific notation. A token-shape screen can help identify values needing an explicit text import policy.1
Flag legacy MARCH#, MARC1/2, SEPT#, or DEC1 symbols and ASCII scientific-notation-shaped cells as spreadsheet import risks; the rule is a heuristic, not a gene registry lookup.
When to use Scientific-Notation Gene-Name Date Guard
Use this for the following task: Flag legacy MARCH#, MARC1/2, SEPT#, or DEC1 symbols and ASCII scientific-notation-shaped cells as spreadsheet import risks; the rule is a heuristic, not a gene registry lookup.
Prepare the CSV text, decoded cells or byte values requested below. Choose delimiter and header flags explicitly when those fields are present.
How to use Scientific-Notation Gene-Name Date Guard and understand its results
- Prepare the CSV text, decoded cells or byte values requested below. Choose delimiter and header flags explicitly when those fields are present.
- Enter values using the field table, then run the tool.
- Read risks. Interpret flags, units, ordering and placeholder values using the rules below.
- Review any reported issue or failed check, correct the supplied values when appropriate, and verify the result in its intended context.
| Input field | Meaning | Value type and bounds | Requirement |
|---|---|---|---|
| values | Values | list of string; minimum entries 0; maximum entries 10000; each entry: string; maximum text length 10000 | Required |
Trim cell values and case-insensitively match MARCH followed by digits, MARC1/2, SEPT followed by digits or DEC1. Independently check signed decimal mantissa plus E exponent syntax and return zero-based risks.2
flag supported legacy date-like gene symbols or ASCII scientific-notation-shaped tokens This summarizes the declared operation. Units, indexing, inclusivity and exceptional cases are explained in the surrounding text.
| Output field | Meaning | Value type |
|---|---|---|
| risks | Risks | list of record: cell (integer), reason (string) |
{
"input": {
"values": [
"SEPT1",
"MARCHF1",
"1E10"
]
},
"output": {
"risks": [
{
"cell": 0,
"reason": "legacy_date_like_symbol"
},
{
"cell": 2,
"reason": "scientific_notation_shape"
}
]
}
}Limitations and assumptions
This is a heuristic without registry lookup or automatic repair. It does not mean every flagged token was converted or corrupted.
Supply the decoded cell strings or raw values declared by the input fields; this tool does not load a spreadsheet file. Malformed requests produce input errors. A successfully evaluated request can still contain false flags, empty result lists or a result outside the supplied threshold; those outcomes have the meanings stated above.
Alternative or Complementary methods
Choose Two-Digit Year Century Window Rule Lookup for this operation: Resolve a two-digit year into a caller-specified inclusive 100-year window, returning the unique year with matching final digits; no operating-system date setting is assumed. For a complementary task, use Mixed-Type Column Detector Samples for this operation: Report observed nonblank ASCII token classes per CSV data column and whether more than one occurs; integer and decimal spellings are distinct classes even when inference can promote both to decimal.
Further background: Format and language reference: Scientific-Notation Gene-Name Date Guard.
References
Similar or alternative tools
- Two-Digit Year Century Window Rule Lookup
Resolve a two-digit year into a caller-specified inclusive 100-year window, returning the unique year with matching final digits; no operating-system date setting is assumed.
- Mixed-Type Column Detector Samples
Report observed nonblank ASCII token classes per CSV data column and whether more than one occurs; integer and decimal spellings are distinct classes even when inference can promote both to decimal.