using RegEx in filterRows?

Find and share HowTos to various installations / configurations!
2 posts • Page 1 of 1
kilianvp
Posts:443
Joined: Fri Jan 16, 2015 10:29 am

using RegEx in filterRows?

Post by kilianvp »

Wow great work with JSONDecode function and the Table element! I can load a 11 MB Json File (45602 x 5 entries) into a Table in 13 seconds. The filterRows function is super fast too!

But i need a RegEX pattern for my 4th column like:

Code: Select all

.*(INFO|SEVERE|FATAL).*
but it wont work :( if i try a number of different filters on the same column the only last one works.

Code: Select all

TABLE1.filterRows(makeDynString("#4"), makeDynString("*INFO*"), true);
TABLE1.filterRows(makeDynString("#4"), makeDynString("*SEVERE*"), true);
TABLE1.filterRows(makeDynString("#4"), makeDynString("*FATAL*"), true);
here a small example of my unfilterted table:

Image
Attachments
table.PNG

kilianvp
Posts:443
Joined: Fri Jan 16, 2015 10:29 am

Re: using RegEx in filterRows?

Post by kilianvp »

nevermind i used a external programm

2 posts • Page 1 of 1