4 Replies Latest reply: Aug 1, 2016 8:20 AM by Avinash R RSS

    Populate Multiple Fields From File

    Deepak Sharma

      Hi

       

      I have a file which is not in apprpriate formate and I want to change the file as per the reporting requirement.

      Source Format

      FullPathTeamBalance
      FIN/IND/Portfolio-1A1222
      GBM/ASP/IND/Portfolio-9/Trader-2C1111
      RB/EUR/FRA/City-1/Trader-6B1555
      EQ/ASP/SL/Portfolio-10/City-3/Trader-9D1333

       

       

      Target Format

      Business FunctionRegionCountryPortfolioCityTrader nameTeamBalance
      FIN-INDPortfolio-1--A1222
      GBMASPINDPortfolio-9-Trader-2C1111
      RBEURFRA-City-1Trader-6B1555
      EQASPSLPortfolio-1AbcCity-3Trader-9D1333

       

       

      Please help me out in finding the solution.