READ DATASET problem

Former Member — Tue, 06 Feb 2007 05:24:32 GMT

Hi all,

In application server I have uploaded tab delimited file. As given below.

US10#000300000213#000004000543#000000#############

US10#000300000390#000004000802#000000#####gc test

US10#000300000392#000004000804#000010#####gc test

US50#000300000410#000004000860#000000#############

US10#000300000650#000004001325#000010#####gc test

US50#000300000701#000004001441#000000#R902011120##

US40#000300000756#000004001554#000010#####gc test

While I am trying to do a READ DATASET, the # is also populated in the internal table fields. as givenbelow.

US10 |#00030000021|3#0000040005|43#000|000#############00|000000###### |

How to avoid this.

Regards,

Balaji

Re: READ DATASET problem

Former Member — Tue, 06 Feb 2007 05:30:45 GMT

1) when evr u r uploading file to a Application server then psl refer this demo code,u shud use separaters in ur internal table..

REPORT ZGILL_AS message-id rp .

tables: pa0001,pa0002.

select-options s_pernr for pa0001-pernr no intervals MODIF ID XYZ.

parameters: p_dwnld AS CHECKBOX ,

p_upld AS CHECKBOX DEFAULT 'X'.

parameters: P_DSNI(75) TYPE C MODIF ID ABG DEFAULT

'/usr/local/sapdata/amit.dat' LOWER CASE.

data: begin of itab occurs 0,

pernr(8),

sp1(1) value ',',

werks(4),

sp2(1) value ',',

persg(1),

sp3(1) value ',',

persk(2),

end of itab.

data: s_eof(3).

start-of-selection.

if p_upld = 'X'.

OPEN DATASET P_DSNI FOR OUTPUT IN LEGACY TEXT MODE.

PERFORM FETCH_DATA.

STOP.

elseif p_dwnld = 'X'.

OPEN DATASET P_DSNI FOR INPUT IN LEGACY TEXT MODE.

IF SY-SUBRC NE 0.

MESSAGE E016 WITH

'Error opening seq. file, RC:' SY-SUBRC.

EXIT.

ENDIF.

CLEAR S_EOF.

DO.

PERFORM FETCH_file.

IF S_EOF EQ 'YES'. stop. ENDIF.

ENDDO.

endif.

END-OF-SELECTION.

if itab[] is not initial.

perform print_file1 tables itab.

else.

write:/ 'No records exists'.

endif.

&----

*& Form FETCH_DATA

&----

text

----

--> p1 text
<-- p2 text

----

FORM FETCH_DATA .

SELECT * FROM PA0001 WHERE PERNR IN S_PERNR.

MOVE-CORRESPONDING PA0001 TO ITAB.

TRANSFER ITAB TO P_DSNI.

APPEND ITAB.

ENDSELECT.

CLOSE DATASET P_DSNI.

ENDFORM. " FETCH_DATA

&----

*& Form FETCH_file

&----

text

----

--> p1 text
<-- p2 text

----

FORM FETCH_file .

READ DATASET P_DSNI INTO itab.

append itab.

clear itab.

IF SY-SUBRC NE 0.

S_EOF = 'YES'. EXIT.

ENDIF.

ENDFORM. " FETCH_file

&----

*& Form print_file1

&----

text

----

-->P_ITAB text

----

FORM print_file1 tables P_ITAB structure itab .

write:/2 'EmpNo',

14 'Personnel Area',

34 'Emp Group',

47 'Emp SubGroup'.

skip 1.

loop at p_itab.

write:2 p_itab-pernr,

14 p_itab-werks,

34 p_itab-persg,

47 p_itab-persk.

skip 1.

endloop.

ENDFORM. " print_file1

2) for ur requirement -

READ DATASET P_DSNI INTO itab.

split itab at '#' into itab1-field1 itab1-field2 itab1-field3 itab1-field4.

append itab1.

Re: READ DATASET problem

Former Member — Tue, 06 Feb 2007 05:31:35 GMT

Hi,

Try this..

Use SPLIT AT statement

SPLIT STRING AT cl_abap_char_utilities=>horizontal_tab INTO s_struc-matnr................

Thanks,

Naren

topic Re: READ DATASET problem in Application Development and Automation Discussions

READ DATASET problem

Re: READ DATASET problem

Re: READ DATASET problem