title: Splunk: how to extract fields using regular expressions? like rex in splunk search
body: <p>I want to extract Primary and StandyBy DB names from the below string which I found in my splunk search.</p>
  
  <p>Jul 20 14:43:31 XXXXXXXX GuptaA  GuptaA - Primary database GuptaC - (*) Physical standby database GuptaB - Physical standby database.</p>
  
  <p>Jul 20 14:43:31 XXXXXXXX KumarA KumarA - Primary database KumarC - (*) Physical standby database KumarD - Physical standby database - Physical standby database KumarE - Physical standby database</p>
  
  <p>Primary DB : GuptaA
  SecondaryDBs : GuptaC, GuptaB</p>
  
  <p>I want to show a table with below details.</p>
  
  <p>Primary DB            StandyByDB </p>
  
  <p>GuptaA                  GuptaC, GuptaB
  KumarA                 KumarC, KumarD, KumarE</p>
  
  <p>Any suggestions using splunk search? </p>
  
  <p>Thank you!</p>