- In Notepad++, click Search > Find.
- Click the Replace tab.
- Under the Search Mode group, select Regular expression.
- In the Find what text field, type
],\s*
- In the Replace with text field, type
],\n
- Click Replace All.
sample
<pre><code>['22APR2012 23:10', '23APR2012 07:10', 1, 3, 0], ['22APR2012 23:10', '23APR2012 07:20', 1, 3, 0], ['22APR2012 23:15', '23APR2012 06:40', 0, 1, 0], ['22APR2012 23:15', '23APR2012 06:40', 1, 3, 0], ['22APR2012 23:15', '23APR2012 06:40', 0, 1, 0], ['22APR2012 23:15', '23APR2012 07:00', 1, 3, 0], ['22APR2012 23:15', '23APR2012 07:00', 0, 1, 0], ['22APR2012 23:20', '23APR2012 09:35', 0, 1, 0], ['22APR2012 23:20', '23APR2012 09:35', 1, 3, 0], ['22APR2012 23:20', '23APR2012 10:10', 1, 3, 0], ['22APR2012 23:25', '23APR2012 05:35', 1, 3, 0], </code></pre>
output
<pre><code> ['22APR2012 19:30', '23APR2012 00:25', 0, 1, 0], ['22APR2012 19:35', '23APR2012 01:45', 1, 3, 0], ['22APR2012 19:50', '23APR2012 05:25', 1, 3, 0], ['22APR2012 19:50', '23APR2012 05:25', 0, 1, 0], ['22APR2012 19:55', '23APR2012 06:25', 1, 3, 0],</code> <code> </code></pre>