Filter Rows Numeric > Threshold
Keep CSV data rows whose selected column is strictly greater than an exact dot-decimal threshold; malformed numeric cells fail instead of being rounded or ignored.
Description
Numeric row filtering should compare numeric values rather than text order.
Numeric row filtering should compare numeric values rather than text order. Exact decimal strings preserve distinctions that binary floating point could round away.1
Keep CSV data rows whose selected column is strictly greater than an exact dot-decimal threshold; malformed numeric cells fail instead of being rounded or ignored.
When to use Filter Rows Numeric > Threshold
Use this for the following task: Keep CSV data rows whose selected column is strictly greater than an exact dot-decimal threshold; malformed numeric cells fail instead of being rounded or ignored.
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 Filter Rows Numeric > Threshold 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 csv, delimiter, hasHeader, column, threshold using the field table, then run the tool.
- Read csv. 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 |
|---|---|---|---|
| csv | CSV text | string; maximum text length 100000 | Required |
| delimiter | Delimiter | string; choose ",", ";", "\t" | Required |
| hasHeader | Has header | boolean | Required |
| column | Column | integer; minimum 0 | Required |
| threshold | Threshold | string; maximum text length 200 | Required |
Parse rectangular records and preserve an explicit header. Validate zero-based column and dot-decimal threshold, parse every selected data cell and retain strictly greater values in original order.2
Parse delimiters only outside quoted fields and decode doubled quotes. A quoted line break stays inside its cell; malformed quoting is returned as an input error.
The shared writer doubles interior quotes and quotes cells when needed for delimiters or line breaks, including a single empty-field record. It normally emits LF record endings without a terminal newline; any tool-specific quote-all behavior is stated above.
keep when exact cell decimal > exact threshold decimal This summarizes the declared operation. Units, indexing, inclusivity and exceptional cases are explained in the surrounding text.
| Output field | Meaning | Value type |
|---|---|---|
| csv | CSV text | string |
{
"input": {
"csv": "id,amount\na,9007199254740993\nb,9007199254740992",
"delimiter": ",",
"hasHeader": true,
"column": 1,
"threshold": "9007199254740992"
},
"output": {
"csv": "id,amount\na,9007199254740993"
}
}Limitations and assumptions
Blank or malformed numeric cells cause errors, rather than being skipped. Grouping/exponent spelling is excluded. Decimal parsing trims outer whitespace, requires digits before the separator and limits a numeric token to 200 characters.
Where CSV is parsed, the shared parser accepts comma, semicolon or tab separators, doubled quotes and quoted line breaks, with CR/LF/CRLF record endings. Blank records remain records. CSV inputs are bounded to 100000 UTF-16 units and 10000 fields. 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 Filter Rows Column Equals Value for this operation: Keep CSV data records whose selected zero-based column exactly equals a supplied decoded string, preserving an explicit header and original record order. For a complementary task, use Numeric Sort EU Decimal-Aware for this operation: Stably sort rectangular CSV rows by exact numbers using comma decimals and optional dot groups of three, preserving original cell spelling and an explicit header.
Further background: Format and language reference: Filter Rows Numeric > Threshold.
References
-
Format and language reference: Filter Rows Numeric > Threshold — RFC Editor
-
Filter Rows Numeric > Threshold — tool.io
Similar or alternative tools
- Filter Rows Column Equals Value
Keep CSV data records whose selected zero-based column exactly equals a supplied decoded string, preserving an explicit header and original record order.
- Numeric Sort EU Decimal-Aware
Stably sort rectangular CSV rows by exact numbers using comma decimals and optional dot groups of three, preserving original cell spelling and an explicit header.