Exporting from Server Reporting Services to Text and deleting comas

• les.61

  SSC Eights!

  Points: 849

  More actions

  November 21, 2014 at 9:10 pm

  #292218

  I have a report that can have 25 records per line of accounts. (I have to have the data as name , address, etc and then details of account 1, account 2, etc.) Each account has to be made up of 15 columns. The problem I have is that when I export to csv and open in text it leaves comas for the blank fields. As some records will have 1 account and some 2 etc I have to manually delete the commas at the end of the data plus the total from the trailer.

  Any suggestions on an easy fix to delete these commas and keep the trailer on the last line rather then the end of each line? Opening in Excel and then saving does help but as it has more then 256 columns that is not possible.

  An example of a record with 1 account is

  A B Smith,Open,Non-prescribed,123-456,999999S75,cheque,cheque account,6444.55,6444.50,0.00,6444.50,0.05,0.00,0.00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,437

  With 2 accounts would be

  A B Smith,Open,Non-prescribed,123-456,999999S75,cheque,chequeaccount,6444.55,6444.50,0.00,6444.50,0.05,0.00,0.00,A B Smith,Open,Non-prescribed,123-456,999999S76,cheque,chequeaccount,125.55,125.50,0.00,125.50,0.05,0.00,0.00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,437