Change 3rd and 4th delimeters in every line from a comma to a pipe with (PHP)
<p>I have a file with about 30 or 40 lines. The file looks similiar to this:</p>

<pre><code>1234567899,05/30/13,1430,10,ANDERSON MONTE
4567891234,06/01/13,930,10,ANDERSON JENNIFER
7891234567,06/02/13,1515,10,ANDERSON MONTE
</code></pre>

<p>Now, I need to change the comma in ever line around the time to pipes. I also need to change it from 24 hour time to 12 hour with the AM or PM behind it. I am reading all this from a file and not from a database unfortunately. So I need it to end up looking like this:</p>

<pre><code>1234567899,05/30/13|02:30PM|10,ANDERSON MONTE
4567891234,06/01/13|09:30AM|10,ANDERSON JENNIFER
7891234567,06/02/13|03:15PM|10,ANDERSON MONTE
</code></pre>

<p>Any help would be appreciated. I would like to use PHP if possible.  It started out as a report that I've been able to strip down to the above.</p>

<p>Thank you in advance.<br>
Monte</p>
