topic Re: Problem in Upload and Split in Application Development and Automation Discussions

Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:08:19 GMT

Hello All,

I have one text file with 'TAB' seperated fields. When i am uploading this file into UNIX server(thru customize prog) fille uploaded successfully but it take field sepration '#' instead of 'TAB'.

now uploaded file looks like

AAA#BBB#CCC#DDD#

Now if i am split this file to '#' it is not heppening.

DATA: BEGIN OF T_TEMP OCCURS 16,

TEXT(300),

END OF T_TEMP.

DATA: LV_FILE(3000).

DATA: L_INT TYPE I,

L_COUNT TYPE I. "For index

DO.

READ DATASET INPUT INTO LV_FILE.

IF SY-SUBRC = 0.

SPLIT LV_FILE AT '#' INTO TABLE T_TEMP.

endif.

enddo.

Can any body help me out.

Rgds,

Paras

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:10:12 GMT

Hi,

I am not finding OPEN Dataset statement, please check. Since you cannot read a dataset without opening it.

Also check that

READ DATASET INPUT INTO LV_FILE.

returns sy-subrc eq 0.

Thanks & Regards,

Navneeth K.

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:12:13 GMT

Modify code as:

DATA: BEGIN OF T_TEMP OCCURS 16,

TEXT(300),

END OF T_TEMP.

DATA: LV_FILE(3000).

DATA: L_INT TYPE I,

L_COUNT TYPE I. "For index

open dataset INPUT for input in text mode.

if sy-subrc eq 0.

DO.

READ DATASET INPUT INTO LV_FILE.

IF SY-SUBRC = 0.

SPLIT LV_FILE AT '#' INTO TABLE T_TEMP.

endif.

enddo.

endif.

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:14:22 GMT

Split your string at CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB which corresponds to the keyboard TAB key.

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:15:59 GMT

Tab equivalent is '#' , you can replace that with the help of

utlities class.

use cl_abap_char_utilities=>horizontal_tab instead of '#'.

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:17:06 GMT

Hi Navneet,

Thanks for your promt reply.

I already open dataset.

problem in split the string on '#' . system is not reading '#' symbol.

Paras

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:22:07 GMT

Can you check the contents of lv_file after read statement is it just like format you gave : AAA#BBB#CCC#DDD#

I tried the sample code it works:

DATA:
  str TYPE string VALUE 'AAA#BBB#CCC#DDD#'.

DATA:
  BEGIN OF itab OCCURS 0,
    data(255),
  END OF itab.

SPLIT str AT '#' INTO TABLE itab.

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:22:52 GMT

Thank you Manoj and Vijay...

You are great!!!!!

Thanks once again.

Paras

Re: Problem in Upload and Split

Former Member — Thu, 30 Oct 2008 10:24:22 GMT

The '#' is not normal one. simple replace or split will not work, tab(key board) will be displayed as '#' , though it appears as '#' it won't recognize when you use split or replace using normal '#'.