How can I export to csv without the suppressed detail which shows commas?

[Former Member]

my output looks like:

"Security Identifer","Description","Start Date","End Date","List Type","User Group","Action","Reason","Notes","Created By","Requestor","Review Date"

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

"BMG4491W1001","MIDLAND HOLDINGS",0202161135,,"R",,"AD",,"2,261,840,000.00","ddenton@twinvest.com",,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

"KYG0420V1068","AMVIG HOLDINGS LTDCOM",0202161135,,"R",,"AD",,"2,907,920,000.00","ddenton@twinvest.com",,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

[DellSC]

You'll need to filter the data in the Select Expert using the same formula you're using suppress the details.  This way the data won't ever come into the report so you won't have any rows that are suppressed in the first place.

-Dell

[Former Member]

Hello Dell,

Thank you for your response.  I have tried every type of suppress and hide on the select expert as well as on the export.  Am I missing something?

Debbie

[Former Member]

Another option is to remove these blank commas using powershell,

I need to have a csv file and I've attempted to convert a txt file to csv using powershell without success as of yet.

the powershell output takes all my columns and places all the data into the first column on the output.

[DellSC]

Is there something specific in your report that is causing the need to suppress rows?  Can you post and image of your report design?

-Dell

[Former Member]

See attached sample.

I am aggregating data using sums and mode to produce the report.

thanks again,

Debbie

[DellSC]

Try taking all of the fields out of the details section and turning on "Suppress Blank Section" for the details and Group Header 1 sections.

-Dell