topic Re: how to split a table fields and create a new record for each split in Application Development and Automation Discussions

how to split a table fields and create a new record for each split

Former Member — Fri, 09 May 2008 21:43:00 GMT

Hi,

Could any one let me know how to split a table with strucutre and create a new record for each split. structure is as follow:

Filed1

Filed2

Filed3 more than one value seperated wtih commas

I need to split Filed3 values and create a new record for each split. Split is on comma operator.

Thanks

Rajeev.

Re: how to split a table fields and create a new record for each split

Former Member — Fri, 09 May 2008 21:47:54 GMT

Are the new records going to be in the same table? here is an example with a second table.


data: itab2 type table of string,
        itabaux like itab2.

loop at itab.
split itab-field3 at ',' into table itabaux.
append lines of itabaux to itab2.
endloop.

itab2 should have all the records

Re: how to split a table fields and create a new record for each split

Former Member — Fri, 09 May 2008 22:14:42 GMT

No It has to update in another table.

Re: how to split a table fields and create a new record for each split

Former Member — Sat, 10 May 2008 03:49:25 GMT

example by ramiro is for another table only

Re: how to split a table fields and create a new record for each split

Former Member — Sat, 10 May 2008 07:27:56 GMT

I have the webserice commming in in the following strucutre:

- <COUNTRIES>

<F_COUNTRY_CODE>ABW</F_COUNTRY_CODE>

<F_COUNTRY_NAME>ARUBA</F_COUNTRY_NAME>

- <F_LANGUAGE>

<F_LANGUAGE_CODE>DUT, ENG, FRE, SPA</F_LANGUAGE_CODE>

<F_LANGUAGE_NAME>DUTCH; FLEMISH, ENGLISH, FRENCH, SPANISH; CASTILIAN</F_LANGUAGE_NAME>

</F_LANGUAGE>

- <F_REGION>

<F_REGION_CODE>LA</F_REGION_CODE>

</F_REGION>

</COUNTRIES>

I need to split the data coming in at "," and create new records for each split value (country code+name). Could any one guide me on this.

Thanks

Rajeev

Re: how to split a table fields and create a new record for each split

Former Member — Sat, 10 May 2008 07:47:01 GMT

hi check this..

this can be done through the command split in additon with table

syntax : SPLIT f AT g INTO TABLE itab.

Stores the components of f in the internal table itab . For each part of f , a "special" table line is created.

f is considered without trailing blanks.

Example

DATA: BEGIN OF ITAB OCCURS 10,

WORD(20),

END OF ITAB.

SPLIT 'STOP Two STOP Three STOP ' AT 'STOP' INTO TABLE ITAB.

Now, ITAB has three lines. The first line is blank, the second contains 'Two' and the third contains 'Three' .

regards,

venkat .

Re: how to split a table fields and create a new record for each split

Former Member — Sat, 10 May 2008 09:52:55 GMT

Hi Rajeev,

DATA: str1 TYPE string,

str2 TYPE string,

str3 TYPE string,

itab TYPE TABLE OF string,

text TYPE string.

text = `What a drag it is getting old`.

SPLIT text AT ',' INTO: str1 str2 str3,

TABLE itab.

Edited by: jagadeesh tirumalasetti on May 10, 2008 12:09 PM