title: transpose column into rows through delimiter
body: <p>I have data in the following format. The values are in one column. I need to transpose them keeping the delimiter. I tried replacing the values using regular expression '\r\n' but it does nothing. </p>
  
  <pre><code>653
  |110
  |1 January 2016
  |Default
  |Automatically identified, customer dialed
  |None
  |NPA dialed by customer
  |000-380-5414
  |03:59:57.5
  |4:01.9
  |CIC = 0000 |1 January 2016
  |03:59:35.5
  |4:23.9
  |10
  |SS7 from IC to AT, SS7 to EO |Tandem
  |104
  |Routing Indicator = Direct - Incoming Different network |104
  |Routing Indicator = Direct - Outgoing Different network |119
  |Trunk Group Number - Interoffice = 9056 |Network Interface Description = Feature Group D
  |Administrative Domain = 0 |Final module
  |
  625
  |119
  |1 January 2016
  |Default
  |Automatically identified, customer dialed
  |None
  |000-000-0000
  |NPA dialed by customer
  |000-380-5084
  |04:04:26.6
  |0:00.0
  |CIC = 0000 |1 January 2016
  |04:04:24.6
  |0:01.9
  |01
  |SS7 from IC to AT, SS7 to EO |Tandem
  |CAC not dialed, station not presub, no presub ind
  |Neither ANI nor CPN provided
  |104
  |Routing Indicator = Direct - Incoming Different network |104
  |Routing Indicator = Direct - Outgoing Different network |119
  |Trunk Group Number - Interoffice = 9056 |Network Interface Description = Feature Group D
  |Administrative Domain = 0 |Final module
  |
  </code></pre>
  
  <p>How do i convert this to the following structure </p>
  
  <pre><code>653|110|1 January 2016|Default|...
  652|119|1 January 2016|Default|...
  </code></pre>
  
  <p>I have textpad and notepad++. Any assistance is much appreciated...</p>