I have several groups of columns, each with hundreds of columns in each group, with the names ending in particular descriptions ("(Count*)", “(Count*)_Percentage”, and “Binary”).
Setting the Column Splitter Wildcard to any of the three (ie: (Count)) easily returns the full column series.
This is possible to do using the “Regular expression” option. One just needs to write separately the regular expressions required for each one of your desired group of columns and then put them together using a vertical bar | (“or” operation for regex).
For instance, let say we want to filter in the following columns defined as:
something followed by (Count*)
something followed by (First*)
something followed by (Average*)
where * is part of the column name. A simple way of writing the three regex would be:
.*\(Count\*\) .*\(First\*\) .*\(Average\*\)
* and ) need to be preceded by a \ because they are exreg metacharacters which have a meaning in regular expressions.
Then one just needs to put the three regex together separated by a vertical bar | to say “either” select this “or” that:
.*\(Count\*\)|.*\(First\*\)|.*\(Average\*\)
I have simulated an example here below for .*\(First\*\)|.*\(Last\*\) :