title: How to read a file where one column data is present in other column using Talend Data Integration
body: <p>I get data from a CSV format daily.</p>
  
  <p>Example data looks like:</p>
  
  <pre><code>Emp_ID     emp_leave_id           EMP_LEAVE_reason             Emp_LEAVE_Status  Emp_lev_apprv_cnt
  
   E121          E121-         21 Head ache, fever, stomach-ache    Approved            16
  
   E139          E139_         5 Attending a marraige of my cousin  Approved            03
  </code></pre>
  
  <p>Here you can see that <code>emp_leave_id</code> and <code>EMP_LEAVE_reason</code> column data is shifted/scattered into the next columns.</p>
  
  <p>So the problem by using tFileInputDelimited and various reading patterns I couldn't load data correctly into my target database. Mainly I'm not able to read the data correctly with that component in Talend.</p>
  
  <p>Is there a way that I can properly parse this CSV to get my data in the format that I want?</p>