title: How to extract multiple values as multiple column data from filename by Informatica PowerCenter?
body: <p>I am very new to Informatica PowerCenter, Just started learning. Looking for help. My requirement is : I have to extract data from flat file(CSV file) and store the data into Oracle Table. Some of the column value of the target table should be coming from extracting file name.</p>
  <p>For example:
  My Target Table is like below:</p>
  <p>USER_ID     Program_Code       Program_Desc        Visit Date     Term</p>
  <hr />
  EACRP00127         ER Special Visits    08/02/2015      Aug 2015
  <p>My input filename is: Aug 2015 ER Special Visits EACRP00127.csv</p>
  <p>From this FileName I have to extract &quot;AUG 2015&quot; as Term, &quot;ER Special Visits&quot; as Program_Desc and &quot;EACRP00127&quot; as Program_Code along with some other fields from the CSV file.
  I have found one solution using &quot;Currently Processed Filename&quot;. But with this I am able to get one single value from filename. how can I extract 3 values from the filename and store in the target table? Looking for some shed of light towards solution. Thank you.</p>