Row Splitter and Row Filter with string range/boundary comparisons

[takbb]

With reference to the following posts:

New Row Filter neither supports wildcard, regex, boundary filtering etc.

Internal ticket ID: AP-22915 Fix version(s): 5.3.2, 5.4.0 Other related topic(s): -

and

Row Splitter without all options as the previous version

Hi guys, The new “Row splitter node” don’t came with some operators as the previous version, only as the picture below: [image] From the help menu, it explains that it have all option as previous. [image] Other point, the selection topics too: [image] [image] I believe that have some explanation ablut it, but the node lost functions that I use actually. Can I tell me if is it in development? some info abou it? Thanks, Denis

and specifically the following fix

Internal ticket ID: AP-22915
Fix version(s): 5.3.2, 5.4.0

I note that range/boundary conditions are still not available in Row Filter and Row Splitter for String columns, which came as a surprise to me.

Although one of the suggested workarounds for boundary filters on other data types was to use two comparison conditions (for lower and upper boundary) within the same filter, this is not available for String data.

Are there any plans to implement this, so that we don’t have to resort to the use of Row Filter //deprecated, or one of the “scripting” filters/splitters.

e.g, the following trivial example would retrieve all animals within an alphabetic range:

Another more common example is filtering dates held as strings without having to first convert them to date. (e.g. because they’ve just been pulled out of json - which, incidentally, was the catalyst for this post)

**Deprecated Row Splitter **

Row Splitter

[hotzm]

Thanks for the feedback and pointing out its usefulness.

I created a ticket (AP-23816) targeting ordering-based filtering for Strings, with support for natural or lexicographic comparison, like in the Sorter node.

The “between” operator is still tracked in UIEXT-2006.

Best,
Manuel