Skip to Content
0

No delimiters after submit statement so that data in excel is not getting filled properly

Mar 08, 2017 at 10:47 AM

13

avatar image

I want to send email with attachment in an excel format. Data for sending the email is getting from output of another program which is the customized one by using submit statement. After submit statement, im getting output from the report by using LIST_FROM_MEMORY & LIST_TO_ASCI. This output which im getting from LIST_TO_ASCI does not have any delimiters. When im passing this data without delimiters as email attachment , entire text is coming in single column irrespective of coming in separate columns.

For Example:

I want output in Excel like this,

Data should be filled in separate columns,

   A      B        C       D 
field1 field2  field3    field4
  111    112     113      114

But im getting output like

Data filling in single column,

            A     
field1  field2 field3 field4
   111   112   113     114
   221   222   223     224

After LIST_TO_ASCI function module, Im getting delimiters only at the starting position. Tats y it is coming in single column. Pls suggest me wat have to be done for getting delimiters for each n every field. Please help

Please help,

Thanks in Advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers