Report output Export to CSV issue

[Former Member]

Hi Experts,

I have a Bex Query. After running the report when I export the report in CSV format using "Export to CSV" from the report output screen, the data
is being dumped in different columns And when i try to convert that particular CSV file to Excel as we can only select one single column for delimiting the values using a separator into different cells the data in the other column is being truncated.

Kindly suggest me how to resolve this.

Thanks in Advance,

Sushma

[former_member194898]

Hi,

(If anything else on the BW side doesn't help).

Not so long ago I had a similiar problem all data (originally taken from several columns) were in one column - solved it with the help of VB coding.

Sth like this could help you.

Regards, Leszek

    Dim tekst As String
    last_row = Selection.SpecialCells(xlCellTypeLastCell).Row
    Range("A1:Z" & last_row).Select
    Cells.Select
    Selection.NumberFormat = "@"
    For wiersz = 1 To last_row
         Cells(wiersz, 1).Select
         tekst = Selection.Value
         Cells(wiersz, 1).Value = Left(tekst, 21)
         Cells(wiersz, 2).Value = Right(Left(tekst, 27), 6)
         Cells(wiersz, 3).Value = Right(Left(tekst, 37), 10)
         Cells(wiersz, 4).Value = Right(Left(tekst, 50), 13)
     ...
    Next wiersz

[former_member186053]

Hi Sushma,

Are you running query from RSRT or Portal. You have an option in RSRT as 'export to excel file'.

Regards,

Vengal.

[Former Member]

Hi Vengal,

I have executed it through the BEx query designer. And if I export the report output to Excel its working fine.

But my requirement is to Export the rept output to CSV and then convert it to Excel.

Can you please do the needful.

Thanks

Sushma

[former_member186053]

Hi Sushma,

You have the option to download data into Excel, then why you want to take output into CSV and then convert it to Excel file.

Take the help of Excel expert regarding delimiting the values.

You will get some third party tools to convert CSV file into Excel file. Just Google it.

Regards,

Vengal.