Maybe they never worked, but I want to remove two rows from a table: colormap and diffusemap
if I select by specified names and use:
^colormap
it removes colormap from the selection, but if I use:
^colormap ^diffusemap
it will select the entire table
I dare call this a bug! I really need to delete multiple (about 15) rows from a table, and this seems to be the only way?
d
I feel you. Don’t know if it ever worked as none of my posts regarding this were answered. Maybe it’s just that a weird syntax is necessary. (I believe I got ^foo[0-3] working once, but that’s not really useful). So I agree: ^ filtering should be fixed/extended to support multiple patterns.
There might be a workaround. You could use an evaluate DAT to put something like -1 in every rowname that matches one of the 15 rownames you wanna delete. Then you can use ^-1 in the rownames of the select DAT. Not sure, but should work.
I believe that is a missing feature.
Anyhow, I build a little component that does the job with the help of a Merge DATs “Replace Columns” feature and a Select DAT following almost the same approach Achim explained.
you would have to change it a little bit for more then 1 column but that shouldn’t be to hard.
Still this is an important RFE.
cheers
markus
deleteRows.tox (1.01 KB)
in build 1700+, strings with a ^ in front of it will bee matched as ANDs, evertying else as ORs. i.e. ‘^a ^b ^c d e’ matches as ‘(^a AND^b AND ^c) OR d OR e’. this also means that ‘^a* aa’ will match aa.
Selina