Field Seperator in excel sheet

[Former Member]

Hi everyone,

I m populating an excel sheet with fields from an internal table using fm GUI_DOWNLOAD. I want to add ~ symbol as seperator for each fields. If i use the WRITE_FIELD_SEPARATOR = '~' i am getting a box symbol as field seperator. I tried with other symbols like #, but then too i am getting the box symbox in output excel sheet and not the required symbol. I kindly request you to help me in this issue.

[Former Member]

Hi,

I feel the field separator used here is only TAB and not other characters if you are getting something else then check for the unicode compatibilty for the program.

Thanks

Sudharshan

[Former Member]

so what should i do to put a field seperator as a symbol like ~ or #

[Former Member]

Hi,

There is a class(cl_abap_char_utilities), in it all the symbols (like: newline, horizontal_tab, vertical_tab...etc) are defined in Attributes which are static. so you can use them from that class. please find the below piece of code.

Type X value '09' --> TYPE c VALUE cl_abap_char_utilities=>horizontal_tab
Type X value '0A' --> TYPE c VALUE cl_abap_char_utilities=>newline
Type X value '0D' --> TYPE c VALUE cl_abap_char_utilities=>cr_lf

Thanks,

Ravi

[Former Member]

Hi

To get field separator other than TAB you need to

U need to insert the separator'~' directly in internal table with the record of the file, so while you're filling the field of the file, you have to insert the separator.

Thanks

Sudharshan