gui_download codepage

[Former Member]

hi,

I am having trouble in viewing the excel file,

I have this guid_dowload using codepage 4103 to view the korean characters

when i open the text file it looks fine the korean characters are there but when i

open in excel file, the korean characters are still there but it was displayed in one column,

i still have to do the te-to-columns procedure t view it in separate columns are there

any solutions available so that when i open the file in excel it will be automatically tabbed delimited?

[Former Member]

hi,

I am having trouble in viewing the excel file,

I have this guid_dowload using codepage 4103 to view the korean characters

when i open the text file it looks fine the korean characters are there but when i

open in excel file, the korean characters are still there but it was displayed in one column,

i still have to do the te-to-columns procedure t view it in separate columns are there

any solutions available so that when i open the file in excel it will be automatically tabbed delimited?

[Former Member]

Hi,

May be you will need to save the file as CSV file. All the field in the CSV file should be seperated by comma.

Cheers,

[Former Member]

yes it was saved as an csv file and it was separated with comma

[Former Member]

Did you pass WRITE_FIELD_SEPERATOR = 'X' in GUI_DOWNLOAD?

[Former Member]

Write field seprator = ',' although by default also it is space.................

[Former Member]

yes i have the field separator = 'X' but it is still the same

[Former Member]

Hi,

Go to control panal -> date, time,langauge setting -> Regional language options the press customize button.

Here place , (Comma) as LIST SEPRATOR. If your text file is seprated by comma.

So if this setting is right you can open the file in excel and data will displayed in each and every column.

Regards,

Shanmugavel Chandrasekaran

[Former Member]

IT WAS ALREADY IN COMMA. PLEASE HELP.

[vinod_vemuru2]

Hi,

Please don't use all caps. Generally it is considered as RUDE

For your question, concatenate all the fields into string variable separated by CL_GUI_FRONTEND_SERVICES=>HORIZONTAL_TAB and append to internal table with single field of type string. Now download this table.

Thanks,

Vinod.

[Former Member]

May i know what are you writing as FILETYPE...

[Former Member]

sorry if you consider that as rude, it wasn't my intention... anyaway, i have no idea on how to use CL_GUI_FRONTEND_SERVICES=>HORIZONTAL_TAB, could you please show me a sample code,,

PS i am using a 'ASC' filetype.

thanks.

[Former Member]

Hi,

If you are downloading CSV file dont use HAS Fieldseprator as X in FM.

Still you encounter this problem.

Then in SAPLOGON pad right click on your system which you are working go to properties.

then press ADVANCED button here you select ENCODING as utf-16le which automatically downloads 4103 format.

don use 4103 in gui_download.

hope it helps,

Shanmugavel chandrasekaran

[Former Member]

@Shanmugavel chandrasekaran

Sorry i did not help me

@Vinod Vemuru

yes it did separate the fields into different columns but the field separator [,] [comma] was gone, please note that this is a CSV file which is viewed in EXCEL.