4 Replies Latest reply on Jun 18, 2015 12:39 PM by 1054466

    Excel to .csv output from XML Publisher Report adds extra comma(",") in the header and footer

    1054466

      Hi,

       

      When we are converting the XML Publisher Report from Excel output to .csv output, extra comma are getting added to the Header and Footer.

       

      Please help and suggest.

       

      Thanks.

        • 2. Re: Excel to .csv output from XML Publisher Report adds extra comma(",") in the header and footer
          1054466

          We are simply using SAVE AS option to save the .xls as a .csv file.

           

          Please let us know if you need any further information.

           

          Thanks.

          • 3. Re: Excel to .csv output from XML Publisher Report adds extra comma(",") in the header and footer
            Jagadekara

            Will you provide both files here with sample data?

            • 4. Re: Excel to .csv output from XML Publisher Report adds extra comma(",") in the header and footer
              1054466


              Hi,

               

              PFA the files for your reference.

               

              Thanks.

               

              Since we are unable to attach the files, sending you a snapshot of the same.

               

              XLS file:

               

              ##HDR1
              222222112762831982307201511480001F1912197930052005
              222222112762831982307201511232001F1912197930052005
              2222221127628320043072015111160001F201119638062006
              2222221127628320083072015111710001F2112196526032001
              222222112762832008307201511529201F2112196526032001
              22222211276283208730720151101F2608195125032008
              2222221153618320893072015111000001F907196826041994
              2222221153618320893072015113380001F907196826041994
              222222115361832089307201511974201F907196826041994
              222222112762832354307201511374001F190619651102011
              222222112762832751307201511-160001F1011195115061998
              222222112762832751307201511262001F1011195115061998
              222222112762832751307201511305851F1011195115061998
              222222112762832800307201511105251F1703197626032001
              222222112762832800307201511182001F1703197626032001
              2222221127630329953072015112001F2408195327102014
              ##FTR16

               

               

               

              CSV file:

              ##HDR,,,,,,,,,,,,,,,,,,,,1,,,,,,,,,,,,,,,,,,,

              222222,1127628,,31982,,3072015,11,,48000,1,F,,,,19121979,30052005,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,31982,,3072015,11,,23200,1,F,,,,19121979,30052005,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32004,,3072015,11,,116000,1,F,,,,20111963,8062006,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32008,,3072015,11,,171000,1,F,,,,21121965,26032001,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32008,,3072015,11,,52920,1,F,,,,21121965,26032001,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32087,,3072015,11,,0,1,F,,,,26081951,25032008,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1153618,,32089,,3072015,11,,100000,1,F,,,,9071968,26041994,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1153618,,32089,,3072015,11,,338000,1,F,,,,9071968,26041994,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1153618,,32089,,3072015,11,,97420,1,F,,,,9071968,26041994,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32354,,3072015,11,,37400,1,F,,,,19061965,1102011,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32751,,3072015,11,,-16000,1,F,,,,10111951,15061998,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32751,,3072015,11,,26200,1,F,,,,10111951,15061998,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32751,,3072015,11,,30585,1,F,,,,10111951,15061998,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32800,,3072015,11,,10525,1,F,,,,17031976,26032001,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127628,,32800,,3072015,11,,18200,1,F,,,,17031976,26032001,,,,,,,,,,,,,,,,,,,,,,,,3072015

              222222,1127630,,32995,,3072015,11,,200,1,F,,,,24081953,27102014,,,,,,,,,,,,,,,,,,,,,,,,3072015

              ##FTR,,,,,,,,,,,,,,,,,,,,16,,,,,,,,,,,,,,,,,,,

               

              Thanks,