I have two tables, item_data and sheet. Both have an index column set to Text format, containing values like “1.1”, “1.2”, “1.10”, “1.3.1”.
When I try to reference a row in sheet using a filter: item_data.Filter(index = thisRow.index)
Coda incorrectly matches both “1.1” and “1.10”. It seems to be forcing a numeric comparison despite the column type being Text.
What I tried:
-
Converting both sides using
ToText()inside the filter:CurrentValue.index.ToText() = thisRow.index.ToText(). -
The issue persists.
Expected behavior: “1.1” should not match “1.10” when doing a text comparison.
Is there a way to enforce strict string equality in filters?
