title: Batch : change tab delimited to pipe delimited
body: <p>Edit Question:</p>
  
  <p>Now, i can change from tab to pipe delimited. But the data have space after text. How to add code in bat to trim space?</p>
  
  <p>Original Question :</p>
  
  <p>I want to create nightly batch process to change text file that seperate by tab delimited to pipe delimited.
  And if the data have space after text. how to trim the space?</p>
  
  <p>Before :</p>
  
  <p>FileName : Customer_Tab.pwf --> that is text file</p>
  
  <p>Data that seperate column by tab delimited: </p>
  
  <pre><code>Customer Number Customer Name   Partner Number  Partner Name    Customer Country
  
  1ABC    Jame    1234    Anny    USA
  
  2DEF    Susan   5678    Prissy  UK
  </code></pre>
  
  <p>Convert to data that seperate by pipe delimited</p>
  
  <p>FileName : Customer_Pipe.csv</p>
  
  <p>Data :</p>
  
  <pre><code>Customer Number|Customer Name|Partner Number|Partner Name|Customer Country
  
  1ABC|Jame|1234|Anny|USA
  
  2DEF|Susan|5678|Prissy|UK
  </code></pre>
  
  <p>Please help me to create batch.</p>
  
  <p>I don't know how to create batch for this question.
  Many thanks in advance.</p>