1 Reply Latest reply: Oct 10, 2013 6:00 AM by _Phil RSS

    How to fetch the Date column(or Month column) from the file name from the specified path in ODI 11g

    4a493fc9-e328-4da7-86a0-4adf8ea661df

      Hi ALL,

       

      Can any one help us regarding How to fecth the Date column(or month column) from the file name specified in the path in a generalized way .

       

      For example :

      file name is :subscribers (Cost) Sep13.csv is specified in the below path

       

        E:\Accounting\documents\subscribers (Cost) Sep13.csv

       

      here I need to fetch the "Sep13" as a Date column in the ODI 11g in the generalized way.

       

       

      Can any one help us in this case as early as possible.