Databases
StackOverflow2013
Postsdbo
POsearching more than one line at a time
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsearching more than one line at a time
    text
    copied!<pre><code>Users of SSS: (Total of 1 license issued; Total of 0 licenses in use) Users of DesignWare-Regression: (Total of 1 licenses issued; Total of 0 licenses in use) Users of FusionVantageLmcInterface: (Total of 2 licenses issued; Total of 0 licenses in use) Users of LMCSwift_Net: (Total of 2 licenses issued; Total of 0 licenses in use) Users of SNPS-Assertions: (Total of 4 licenses issued; Total of 0 licenses in use) Users of VCSAMSCompiler_Net: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VCSAMSRuntime_Net: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VCSPostProcDebugger_Net: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VCSTools_Net: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VCSiCompiler_Net: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VCSiRuntime_Net: (Total of 2 licenses issued; Total of 2 licenses in use) Users of VT_Assertions: (Total of 4 licenses issued; Total of 0 licenses in use) Users of VT_AssertionsRuntime: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VT_Coverage: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VT_CoverageRuntime: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VT_CoverageURG: (Total of 3 licenses issued; Total of 0 licenses in use) Users of VT_Testbench: (Total of 2 licenses issued; Total of 0 licenses in use) Users of VT_TestbenchRuntime: (Total of 2 licenses issued; Total of 2 licenses in use) Users of VT_Visual: (Total of 2 licenses issued; Total of 2 licenses in use) Users of XVCSDebugger: (Total of 2 licenses issued; Total of 0 licenses in use) Users of vera_comp: (Total of 2 licenses issued; Total of 0 licenses in use) Users of vera_debug: (Total of 2 licenses issued; Total of 0 licenses in use) Users of vera_rtime: (Total of 2 licenses issued; Total of 0 licenses in use) </code></pre> <p>i have a data like this.in this i want product name, number of licenses issued,number of licenses used ..how can i get it...please help</p> <p>This is what i have of now.</p> <pre><code> if ($_=~ m/.*users\s+of\s+(.*)\:\s+(Total\s+of\s+(\d)\s+licenses.*\;\A*\s+total\s+of\A*\‌​s+(\d)\A*\s+licenses\s+.*)/gmi) {print "$1,$2,$3}"; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload