5 Replies Latest reply: Aug 1, 2016 8:16 AM by Allu Allu RSS

    Populate Multiple Fields From another Field

    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.

       

      Data is not in order due to missing values.

      For Ex:

      In first record

      Region City and trader name is missing.

       

       

      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.

      Note: