topic Re: delimiter in Application Development and Automation Discussions

delimiter

Former Member — Fri, 16 Feb 2007 04:50:09 GMT

Hi ,

Please help me in this.

When extracting file from program on that time it must be delimiter extracted file (delimeter";" semicolon).

For this what is the logic please help me.

Thanks

Re: delimiter

Former Member — Fri, 16 Feb 2007 04:54:28 GMT

Hi,

Use 'Split' Statement but i don't think this would be required since the FM which you use to extract the data does that if required then you can use this 'SPLIT' statement.

Thanks,

Prashanth

Re: delimiter

Former Member — Fri, 16 Feb 2007 04:55:46 GMT

see the following ex code to read ',' delemeted file.

OPEN DATASET g_file FOR INPUT IN TEXT MODE

ENCODING DEFAULT

IGNORING CONVERSION ERRORS.

IF SY-SUBRC EQ 0.

DO.

READ DATASET g_file INTO FILE.

if sy-subrc = 0.

split FILE at ',' into ITAB-SOL_DOCNO ITAB-SOL_DOCDT

ITAB-WERKS ITAB-LGORT ITAB-MATNR ITAB-ERFMG .

else.

exit.

endif.

APPEND ITAB.

CLEAR ITAB.

ENDDO.

ENDIF.

Re: delimiter

sreeramkumar_madisetty — Fri, 16 Feb 2007 05:00:11 GMT

OPEN DATASET g_file FOR INPUT IN TEXT MODE ENCODING DEFAULT

IF SY-SUBRC EQ 0.

READ DATASET g_file INTO FILE.

if sy-subrc = 0.

split FILE at ',' into itab.

endif.

Regards,

kumar