topic Re: data split problem in Application Development and Automation Discussions

data split problem

Former Member — Sat, 02 Feb 2008 08:54:54 GMT

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.

Re: data split problem

Former Member — Mon, 04 Feb 2008 07:27:21 GMT

'WS_DOWNLOAD' and "DOWNLOAD' are obsolete

U should not use them

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

Narendra

Re: data split problem

Former Member — Mon, 04 Feb 2008 07:55:56 GMT

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.