Table DAT .findCells() not finding?

Bugs
1

Hey Superstars

Either I’m missing something or DAT.findCells() is not working as expected.

Create a Table:

ID Tag           Data
1   0.2 0.10     Apple
2   0.2          Banana
3   
4   0.22         Carrot

All searches look like floats but are cast as strings. When searching the Tag column I can match 0.2 on its own but not when the tag is 2 or more numbers, as in row 1 “0.2 0.10”

Also, a search for “0.1” matches *1.10* which is wrong, especially considering they are supposed to be strings.

My expectation is, when searching for “0.2” match rows 1 and 2. When searching “0.10”, match only row 1.

I’ve tried a guzillion permutations of valuePattern and search term enclosed with *, spaces or blank and nothing meets my needs.

Is this a bug or my misunderstanding? I’m looking for “is this token in this cell?”

Thank You!

P..S. Latest Touch update is Poptastic! Great work folks!

2

Cheers! Please post your tests so we can look at exactly what you’re doing.

3

Thanks for requesting this, as it gave me the focus to see that the issue is really with Delimiters, or lack thereof. I need the fastest way to search a table, thus using findCells() rather than iterating myself and recognising space as a delimiter. If I enclose the tags in a clearly defined delimiter, such as this, <0.2> then find with valuePattern *<0.2>*, it works!

test_findcells.toe (3.9 KB)

1 Like