How to eliminate Extra commas at the end in CSV file,which exported from SSRS

Question

0.00/5 (No votes)

See more:

, +

I'm just Exporting SSRS report to CSV format,where i'm getting extra commas at end of each record as

CSV Format:
274,98027,Issaquah
274,502097814,M
43849,SO43849,
44082,SO44082,
44508,SO44508,
44532,SO44532,

The extra comma appearing at end of rows in "CSV format",for the rows which has NULL values at end in the "Report"

Report Format:

274 98027 Issaquah
274 502097814 M
43849 SO43849 NULL
44082 SO44082 NULL
44508 SO44508 NULL
44532 SO44532 NULL

I have already hided these null columns in report.but i'm getting that comma at end of each row.

Is there any solution to hide extra comma in CSV format?

plz suggest solution for this.

Thanks in advance..

Posted 5-May-15 1:58am

Member 11039257

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2015-05-05T02:08:00

Solution 1

That is the correct output, since csv is a text format and denotes null values by outputting nothing (blank) hence the comma blank for the last columns value.

Posted 5-May-15 2:08am

Mehdi Gholam

Comments

Member 11039257 5-May-15 8:42am

Yes you r correct .But is there any possible way to remove that Comma?

Mehdi Gholam 5-May-15 8:45am

Even if you do you will still get null in your columns.

Member 11039257 5-May-15 9:09am

its ok.i just wannh CSV report file without commas at end in each row

How to eliminate Extra commas at the end in CSV file,which exported from SSRS

1 solution

Solution 1

Add your solution here

Preview 0

How to eliminate Extra commas at the end in CSV file,which exported from SSRS

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us