topic Re: open dataset encoding UTF-8 in Application Development and Automation Discussions

open dataset encoding UTF-8

Former Member — Wed, 20 Jan 2010 08:25:20 GMT

Hello Everyone,

I have developed an extract program which extracts a space separated text file to the application server and this file is picked by another schedule job from the operating system and posted to our SFTP site. The problem which I have is when our partners try to open the file in Notepad++ they are seeing a u201Cnullu201D character in the middle of all the fields. I have solved the issue by manually changing the format of the file to UFT-8 format and it works fine. When I tried to do the same electronically I could not able to achieve it, I donu2019t understand why? Could someone help me with the code below?

Open output file.

OPEN DATASET wf_file FOR OUTPUT IN TEXT MODE ENCODING UTF-8.MESSAGE wf_msg.

This is the code I am using to extract a file with UTF-8 format but the file is in ANSI format.

Thanks,

Pradeep

Re: open dataset encoding UTF-8

kesavadas_thekkillath — Wed, 20 Jan 2010 08:50:15 GMT

Check this link

link:[http://help.sap.com/saphelp_NW70EHP1/helpdata/en/79/c554dcb3dc11d5993800508b6b8b11/content.htm]

link:[BYTE-ORDER MARK|http://help.sap.com/abapdocu_70/en/ABAPOPEN_DATASET_ENCODING.htm]

Re: open dataset encoding UTF-8

Former Member — Wed, 20 Jan 2010 10:19:08 GMT

I am sorry! I cannot find answers from your reply. Thanks for trying.

Re: open dataset encoding UTF-8

Former Member — Wed, 20 Jan 2010 12:33:37 GMT

try this one

OPEN DATASET gv_file FOR INPUT IN TEXT MODE ENCODING NON-UNICODE

WITH SMART LINEFEED.

Re: open dataset encoding UTF-8

Former Member — Wed, 20 Jan 2010 12:41:13 GMT

Just to be clear about my issue, I am extracting a file to the Application server with space in-between fields not a linefeed. I want the file to be extracted in UFT-8 format not in ANSI. That's my requirement.

Hope you have understood.

Thanks,

Re: open dataset encoding UTF-8

Former Member — Wed, 20 Jan 2010 12:46:13 GMT

have you try this code OPEN DATASET gv_file FOR INPUT IN TEXT MODE ENCODING NON-UNICODE

first try and then give reply, this is for UTF-8 format onlyy...........

Re: open dataset encoding UTF-8

kesavadas_thekkillath — Wed, 20 Jan 2010 12:48:09 GMT

This link:[Download File in UTF-8 encoding |http://wiki.sdn.sap.com/wiki/display/ABAP/DownloadFileinUTF-8encoding]says how to download in presentation server.

Jus add BOM in front of the first record.

Follow the same method and add it in your code.

Its clearly mentioned in the link i provided.

Re: open dataset encoding UTF-8

Former Member — Wed, 20 Jan 2010 14:25:26 GMT

Hello Chenna,

I am 200% sure that to write to a file I have to use FOR OUTPUT in the syntax and non-Unicode means "Characters are represented in the file in the code page defined by the text environment current at the time a READ or TRANSFER command is executedu201D. Therefore I Kindly requests you to, not to waste your time and mine.

Thanks,

Re: open dataset encoding UTF-8

Former Member — Thu, 04 Feb 2010 10:57:58 GMT

Hi!

I solved the same problem reading the responses above but looking for the appropriate tools

Use the converter object but for output format : cl_abap_conv_out_ce.

The code should look like this :


DATA : lo_conv      TYPE REF TO cl_abap_conv_out_ce,
             lv_xstring   TYPE xstring.

* Encoding format
lo_conv = cl_abap_conv_out_ce=>create( encoding  = 'UTF-8' ).

TRY. "For BOM if needed
        lo_conv->write( EXPORTING data   = cl_abap_char_utilities=>byte_order_mark_utf8 ).
    CATCH cx_sy_codepage_converter_init .
    CATCH cx_sy_conversion_codepage .
    CATCH cx_parameter_invalid_type .
    CATCH cx_parameter_invalid_range .
ENDTRY.

*here data is a string table but you can use structure with another method
LOOP AT data_table  INTO data_line.
    TRY.
          lo_conv->write( EXPORTING data   = data_line ).
        CATCH cx_sy_codepage_converter_init .
        CATCH cx_sy_conversion_codepage .
        CATCH cx_parameter_invalid_type .
        CATCH cx_parameter_invalid_range .
    ENDTRY.
*   next line!
    TRY.
          lo_conv->write( EXPORTING data   = cl_abap_char_utilities=>cr_lf ).
        CATCH cx_sy_codepage_converter_init .
        CATCH cx_sy_conversion_codepage .
        CATCH cx_parameter_invalid_type .
        CATCH cx_parameter_invalid_range .
    ENDTRY.
ENDLOOP.

*get full content in one xstring 
lv_xstring = lo_conv->get_buffer( ).

* et voila!! 
OPEN DATASET lv_filename FOR OUTPUT IN BINARY MODE.
IF sy-subrc EQ 0.
  TRANSFER lv_xline TO lv_filename.
  CLOSE DATASET lv_filename.
ENDIF.

Hope this help!!

Edited by: LRookie on Feb 4, 2010 1:46 PM

Edited by: LRookie on Feb 5, 2010 9:41 AM