Only show the matching data in virtual columns

Started by Harvey

Harvey

Only show the matching data in virtual columns   06 July 2022, 17:55

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!
SoftPerfect Support forum - Andrew avatar image

Re: Only show the matching data in virtual columns   06 July 2022, 22:07

That's a good point. Indeed nothing should be shown if the regex doesn't match the column value.

Please download the latest build from here and it should work correctly.
Thanx! It's working now as expected! ok, yes, thumb up

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

  ******    ******          **   *******   **      ** 
 **    **  **    **         **  **     **  **  **  ** 
 **        **               **         **  **  **  ** 
 **        **   ****        **   *******   **  **  ** 
 **        **    **   **    **         **  **  **  ** 
 **    **  **    **   **    **  **     **  **  **  ** 
  ******    ******     ******    *******    ***  ***  

Message: