Skip to Content
author's profile photo Former Member
Former Member

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

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,

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

Add comment
10|10000 characters needed characters exceeded

0 Answers