Rowfilters - use length or regex

  • Thread starter Thread starter Masa Ito
  • Start date Start date
M

Masa Ito

The rowfilter in a dataview seems to support a very limited subset of regex
expressions.

I need to filter a column of strings by their length. ie: if 2 character
code, or 3 character code.

Currently, I am looping all the rows, and deleting them when they don't
match the length. Resetting/loading the datasource every time a new filter
is applied. This is slow - I need a better way.

Does anyone have any ideas?

Masa
 
The rowfilter in a dataview seems to support a very limited subset of
regex expressions.
I need to filter a column of strings by their length. ie: if 2
character code, or 3 character code.
Currently, I am looping all the rows, and deleting them when they
don't match the length. Resetting/loading the datasource every time a
new filter is applied. This is slow - I need a better way.
Does anyone have any ideas?
Click to expand...

Answering myself - I gave up, after researching a bit more - apparently
regex and rowfilters don't work too well. I ended up creating another
column, assigning length to it, and using it for the rowfilter.

Masa
 
Back
Top