data split problem

[Former Member]

there is a " in first place of a series of characters in column of internal table.

when I use function 'WS_DOWNLOAD' to download internal table to a Excel file, the three line is appended to the end of two line.

who can tell me which function can be used to avoid this problem?

data: begin of t_lips occurs 0,

vbeln(10),

text(20),

end of t_lips.

data: begin of t1 occurs 0,

c1(10),

end of t1.

t1-c1 = 'a'.

append t1.

t1-c1 = 'b'.

append t1.

t_lips-vbeln = 'a'.

t_lips-text = 'test'.

append t_lips.

t_lips-vbeln = 'b'.

t_lips-text = '"test'.

append t_lips.

t_lips-vbeln = 'c'.

t_lips-text = 'test'.

append t_lips.

call function 'WS_DOWNLOAD'

EXPORTING

• BIN_FILESIZE = ' '

• CODEPAGE = ' '

FILENAME = 'd:\t2.xls'

FILETYPE = 'DAT'

• MODE = ' '

• WK1_N_FORMAT = ' '

• WK1_N_SIZE = ' '

• WK1_T_FORMAT = ' '

• WK1_T_SIZE = ' '

• COL_SELECT = ' '

• COL_SELECTMASK = ' '

• NO_AUTH_CHECK = ' '

• IMPORTING

• FILELENGTH =

tables

data_tab = t_lips

FIELDNAMES = t1.

[Former Member]

'WS_DOWNLOAD' and "DOWNLOAD' are obsolete

U should not use them

U have to use GUI_DOWNLOAD, then u can solve ur problem

Narendra

[Former Member]

but I wasn't still able to realize my goal according to your advice.

pls help again.

call function 'GUI_DOWNLOAD'

exporting

filename = 'd:\t2.xls'

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

tables

data_tab = t_lips

FIELDNAMES = t1.