topic Re: Split Command is not working.... in Application Development and Automation Discussions

Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 10:23:47 GMT

Hi,

In the application server this file('C:\usr\sap\QAS\DVEBMGS00\work\test1.txt')

contains the data...

asd#c#fert#desc1#kg#00101

as#c#fert#desc1#kg#00101

and the code i have written for this is...

DATA:

P_FILE LIKE RLGRAP-FILENAME VALUE

'C:\usr\sap\QAS\DVEBMGS00\work\test1.txt'.

DATA: V_RECORD(200).

DATA:BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

MBRSH LIKE MARA-MBRSH,

MTART LIKE MARA-MTART,

MAKTX LIKE MAKT-MAKTX,

MEINS LIKE MARA-MEINS,

MATKL LIKE MARA-MATKL,

END OF ITAB.

DATA:BEGIN OF WA,

MATNR LIKE MARA-MATNR,

MBRSH LIKE MARA-MBRSH,

MTART LIKE MARA-MTART,

MAKTX LIKE MAKT-MAKTX,

MEINS LIKE MARA-MEINS,

MATKL LIKE MARA-MATKL,

END OF WA.

START-OF-SELECTION.

OPEN DATASET P_FILE FOR INPUT IN TEXT MODE ENCODING DEFAULT.

DO.

READ DATASET P_FILE INTO V_RECORD.

IF SY-SUBRC NE 0.

EXIT.

ENDIF.

SPLIT V_RECORD AT '#'

INTO

WA-MATNR WA-MBRSH WA-MTART WA-MAKTX WA- MEINS WA-MATKL. APPEND WA TO ITAB.

ENDDO.

LOOP AT ITAB INTO WA.

WRITE:/ WA-MATNR.

ENDLOOP.

and the output is coming like this..

asd#c#fert#desc1#k

as#c#fert#desc1#kg

but my output should come like this...

asd

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 10:27:27 GMT

Hi,

Do as below :

loop at v_record.

SPLIT V_RECORD AT '#'

INTO

WA-MATNR WA-MBRSH WA-MTART WA-MAKTX WA- MEINS WA-MATKL.

APPEND WA TO ITAB.

endloop.

Thanks,

Sriram Ponna.

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 10:29:52 GMT

You cannot do a SPLIT by comparing with character '#'. Internally that might be tab separated, or someother field separator being used. But in debugger you might see it as '#'s ... If it is a tab separated file, then may be you can use CL_ABAP_CHAR_UTILITIES->HORIZONTAL_TAB instead of '#' as the field separator.

Regards

Ranganath

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 10:32:45 GMT

Hi,

Do like this

SPLIT V_RECORD AT CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB INTO

WA-MATNR WA-MBRSH WA-MTART WA-MAKTX WA- MEINS WA-MATKL.

Regards,

Satish

Re: Split Command is not working....

former_member404244 — Tue, 22 Jan 2008 10:32:59 GMT

Hi,

Check the below link

Regards,

Nagaraj

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 10:33:25 GMT

Hi Ranganath,

Can you just modify my code and send me your code by using

CL_ABAP_CHAR_UTILITIES->HORIZONTAL_TAB

Regards,

Kiran.

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 10:39:08 GMT

Hi,

i tried but it is showing the error message...

Direct access to components of global class cl_abap_char_utilities is not possible.(cl_abap_char_utilities definition is missing)...

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 10:39:43 GMT

Hi,

after the append statement, clear the wa.

like:

SPLIT V_RECORD AT '#'

INTO

WA-MATNR WA-MBRSH WA-MTART WA-MAKTX WA- MEINS WA-MATKL.

APPEND WA TO ITAB.

clear wa.

enddo.

Regards,

Renjith Michael.

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 10:41:43 GMT

Hi Michael,

Still it is showing same output...

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 10:42:46 GMT

Are you using this symbol => or this ->?

Use =>

Regards,

Satish

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 10:45:10 GMT

Hi Satish,

am using =>

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 10:57:45 GMT

Hi Kiran

May be the file you are reading is not a tab delimited file. If you can provide the right file separator then we can try to help you better. You can download the file to presenatation server and open it in Notepad to get more details.

Regards

Ranganath

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 10:58:43 GMT

Hi,

It is showing...error..

CL_ABAP_CHAR_UTILITIES DEFINITION LOAD Statement missing..

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 11:06:02 GMT

HI ....

Try this.. it will work.

Define a variable which refers to horizontal tab and then use it.

constatns c_tab type ref to CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

SPLIT V_RECORD AT c_tab

INTO

WA-MATNR WA-MBRSH WA-MTART WA-MAKTX WA- MEINS WA-MATKL. APPEND WA TO ITAB.

Regards,

Sai Ramesh

Re: Split Command is not working....

Former Member — Tue, 22 Jan 2008 11:07:38 GMT

Then try this

Data: CR type c value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

SPLIT V_RECORD AT CR INTO

WA-MATNR WA-MBRSH WA-MTART WA-MAKTX WA- MEINS WA-MATKL.

Which Version of SAP R/3 you are using? Can you check whether you have CL_ABAP_CHAR_UTILITIES class is availavble or not?

Regards,

Satish

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 11:16:12 GMT

Hi,

current version is SAP 4.7EE. and in se24 CL_ABAP_CHAR_UTILITIES is available....

Re: Split Command is not working....

former_member188829 — Tue, 22 Jan 2008 14:01:04 GMT

Thanks to all....

Solved by myself.....