1 Reply Latest reply: Mar 11, 2013 4:51 PM by rp0428 RSS

    Upload FIle Contians 3 Different Types of Data Columns

    996070
      Hi All

      I Got a scnario like a upload file contains
      1.Header(Contains the File Name,Branch Name,MIS date)
      2.Body(Customer Details)
      3.Footer (File Name,Contians Total Number of Records and Number of Customers)

      Like

      CustomerDet_11-12-2013.csv,Chennai,11-12-2013

      101,AAA,Savings,'M',10000
      102,BBB,Current,'O',2000
      103,CCC,Deposit Acct,'F',3000

      CustomerDet_11-12-2013.csv,3,15000


      How to handle this scnario through UTL_File .PLs help me to proceed.