7 Replies Latest reply: Jun 15, 2016 8:33 AM by Sunny Talwar RSS

    Pre Processing of file Containing value saperated by semi colon

    Deepak Sharma

      Hi All

       

      I have a requirement to properly format the file while loading.

       

      Original data in file

       

      CountryRegionProduct
      India;BangladeshASPTV
      India;Saudi;UKASP;EUR;MEREF
      India(ASP);UK(EUR)ASP;EURAudio

       

       

      Target format

      CountryRegionProduct
      IndiaASPTV
      BangladeshASPTV
      IndiaASPREF
      SaudiMEREF
      UKEURREF
      IndiaASPAudio
      UKEURAudio