title: Delete the last character in a specific column in unix
body: <p>I have a <strong>|</strong> delimited file in the below format</p>
  
  <pre><code>U|0|1|10.95|10.95|0|0|0|0| |0| |0| |N|N| |N| |10335790_|1| | |Y|N/A|   
  V|0|1|12.65|12.65|0|0|0|0| |0| |0| |N|N| |N| |10335790#|1| | |Y|N/A|   
  P|0|1|15.57|15.57|0|0|0|0| |0| |0| |N|N| |N| |10335790!|1| | |Y|N/A|   
  </code></pre>
  
  <p>I need to delete the last character in the 20th column of all the records.<br>
  "_, #, !" in this case.  </p>
  
  <p>Expected output:</p>
  
  <pre><code>U|0|1|10.95|10.95|0|0|0|0| |0| |0| |N|N| |N| |10335790|1| | |Y|N/A|   
  V|0|1|12.65|12.65|0|0|0|0| |0| |0| |N|N| |N| |10335790|1| | |Y|N/A|   
  P|0|1|15.57|15.57|0|0|0|0| |0| |0| |N|N| |N| |10335790|1| | |Y|N/A|   
  </code></pre>
  
  <p>How can I do that using sed or awk or any unix command. Please note this is not a fixed length file, size of records may vary.</p>