Hello,
When using virtual columns and creating regular expression, if that regex is not matched, the virtual column displays complete data from the source column. Is there a way for a virtual column to show only the matched regex data?
E.g., when I create a virtual column "Check Web" based on the source column "TCP Ports", and do a regex ^.*(80).*$ with replacement expression "Has Web", if there is no port 80 in the source column, only port 22 or 443, those ports will print out in the virtual column, so the output is like this:
[Check Web]
22
22, 443
Has Web
Has Web
22
8291
...
Whereas I would like to hide the data that does not match the regex. Something like this:
[Check Web]
Has Web
Has Web
...
Is this possible?
Thanks!