title: Sql Query to split the string into 2 columns in SQL
body: <p>Below string in SQL needs to be split based on keywords cleared by and clearing for</p>
  
  <pre><code>Paper Industry cleared by SBI
  Chemical Industry cleared by HDFC
  SBI clearing for automobile Industry
  ICICI clearing for textile industry
  </code></pre>
  
  <p>I need to split the above string based on on keywords cleared by and clearing for to get the output in 2 columns</p>
  
  <pre><code>Output 
  Company Name             | Clearer
  ------------------------------------------
  Paper Industry           | SBI
  Chemical Industry        | HDFC
  automobile Industry      | SBI
  textile industry         | ICICI
  </code></pre>
  
  <p>to get 2 columns company name and clearer. </p>
  
  <p>What is the best way to split this and fetch the table valued result in SQL.</p>
  
  <p>SQL query will be helpful.</p>