Hi All,
e
I'm working with RowFilters and trying to get the following to happen.
One of my columns might be doubles. there might be several values like
Column FOO
-------------
392.444444
433.33333
123.333354
2.33331
and I have a separate table that I use to filter these columns
but I'm looking for pattern matching so if the first character that is entered is 3 my table is filtered down 4 my table is filtered down to
Column FOO
-------------
392.444444
433.33333
123.333354
This all works fantastic
however I seem to be having a problem with the .
for example if my filter is 3. my filter seems to be using the . as a "there is a character there"
so the above filtering wont' change. but if I add a 3.2 my results would be
Column FOO
-------------
392.444444
String value = "3.2"
filters.add(RowFilter.regexFilter("(?i)" + value, k));
what I would prefer is that the . be the decimal place, so if I type 3. my filter would be
Column FOO
-------------
433.33333
123.333354
and If I typed 3.2 as my filter, then I would have no results.
Any help would be appreciated.
e
I'm working with RowFilters and trying to get the following to happen.
One of my columns might be doubles. there might be several values like
Column FOO
-------------
392.444444
433.33333
123.333354
2.33331
and I have a separate table that I use to filter these columns
but I'm looking for pattern matching so if the first character that is entered is 3 my table is filtered down 4 my table is filtered down to
Column FOO
-------------
392.444444
433.33333
123.333354
This all works fantastic
however I seem to be having a problem with the .
for example if my filter is 3. my filter seems to be using the . as a "there is a character there"
so the above filtering wont' change. but if I add a 3.2 my results would be
Column FOO
-------------
392.444444
String value = "3.2"
filters.add(RowFilter.regexFilter("(?i)" + value, k));
what I would prefer is that the . be the decimal place, so if I type 3. my filter would be
Column FOO
-------------
433.33333
123.333354
and If I typed 3.2 as my filter, then I would have no results.
Any help would be appreciated.