RTL Override U+202E Hidden Char Detector
Locate every RIGHT-TO-LEFT OVERRIDE U+202E in cell strings with zero-based cell indices and UTF-16 offsets, without changing text or inferring visual order.
Description
RIGHT-TO-LEFT OVERRIDE can change how following text is displayed.
RIGHT-TO-LEFT OVERRIDE can change how following text is displayed. Locating the stored U+202E character helps distinguish logical string content from visual ordering.1
Locate every RIGHT-TO-LEFT OVERRIDE U+202E in cell strings with zero-based cell indices and UTF-16 offsets, without changing text or inferring visual order.
When to use RTL Override U+202E Hidden Char Detector
Use this for the following task: Locate every RIGHT-TO-LEFT OVERRIDE U+202E in cell strings with zero-based cell indices and UTF-16 offsets, without changing text or inferring visual order.
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 RTL Override U+202E Hidden Char Detector 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 locations. 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 |
Scan decoded cells and report zero-based cell indices and UTF-16 offsets in encounter order.2
locations = every U+202E match This summarizes the declared operation. Units, indexing, inclusivity and exceptional cases are explained in the surrounding text.
| Output field | Meaning | Value type |
|---|---|---|
| locations | Locations | list of record: cell (integer), offset (integer) |
{
"input": {
"values": [
"invoicecsv",
"plain"
]
},
"output": {
"locations": [
{
"cell": 0,
"offset": 7
}
]
}
} Limitations and assumptions
Other bidirectional controls are not matched. The tool does not remove controls, infer rendered order or classify intent.
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 Zero-Width Char In Cells Detector for this operation: Locate the explicit format-character set U+200B, U+200C, U+200D, U+2060, and U+FEFF in cells, reporting UTF-16 offsets and code points; this is not a universal glyph-width test. For a complementary task, use Smart Quotes Typographic Replacer for this operation: Replace U+2018/U+2019 with ASCII apostrophes and U+201C/U+201D with ASCII double quotes inside cell strings; CSV escaping belongs to the subsequent writer.
Further background: Format and language reference: RTL Override U+202E Hidden Char Detector.
References
-
Format and language reference: RTL Override U+202E Hidden Char Detector — Unicode Consortium
-
RTL Override U+202E Hidden Char Detector — tool.io
Similar or alternative tools
- Zero-Width Char In Cells Detector
Locate the explicit format-character set U+200B, U+200C, U+200D, U+2060, and U+FEFF in cells, reporting UTF-16 offsets and code points; this is not a universal glyph-width test.
- Smart Quotes Typographic Replacer
Replace U+2018/U+2019 with ASCII apostrophes and U+201C/U+201D with ASCII double quotes inside cell strings; CSV escaping belongs to the subsequent writer.