Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

hi ,related to CSV files out put.

Former Member
0 Kudos
68

hi all,

I am taking out put in ALV and .CSV format (in unix path ) .

And the ALV out put is fine.

In one of the material description the text is like this :

my name is (Activ.Foil+S,sr)

so for description in CSV it is taking like this : my name is (Activ.Foil+S

and for the next field the remaining text is going

i.e , for material group it is getting : sr)

and all the values are shifted by one field.

so the BW team facing the problem while extracting data ,

can any one please help me out how to solve this probelm.

Thanks and Regards.

C.Shamsundher.

1 ACCEPTED SOLUTION

former_member223537
Active Contributor
0 Kudos
42

Hi Prem,

In such case you need to change the delimitter or else remove the comma from Material description once you retrieve data from database into internal table.

REPLACE ALL OCCURRENCES OF ',' in WA_TAB-DESC with ' '.

Then move the material descritpion to the CSV file.

Best regards,

Prashant

3 REPLIES 3

former_member223537
Active Contributor
0 Kudos
43

Hi Prem,

In such case you need to change the delimitter or else remove the comma from Material description once you retrieve data from database into internal table.

REPLACE ALL OCCURRENCES OF ',' in WA_TAB-DESC with ' '.

Then move the material descritpion to the CSV file.

Best regards,

Prashant

Former Member
0 Kudos
42

Use some Other field such as '!' as field seperator.

reward points if helpful.

Former Member
0 Kudos
42

Hi Prem,

after getting into the ITAB ,remove the commma from the material description and modify the itab.

Now transfer the modified Itab to the CSV file.

reward if useful.

sastry