topic Re: internal table help in Application Development and Automation Discussions

internal table help

Former Member — Fri, 27 Jun 2008 12:12:51 GMT

Hi,

I have a line like the following..

A^000001234Griffiths^Timothy ^⁸⁴⁰USNA^{0999CC#0034567841}^^BO098711⁰⁴⁰⁰

I want to get this into an internal table separated by ^ sign, what do i do.

Re: internal table help

Former Member — Fri, 27 Jun 2008 12:14:51 GMT

use SPLIT ...AT..

Regards,

Mohaiyuddin

Re: internal table help

Former Member — Fri, 27 Jun 2008 12:19:33 GMT

Hi,

first declare required number of fields, and one internal table whith those fields.

now by using SPLIT statement, you can read them into some variables.

now assign these variables to internal table and append.

SPLIT string_name at '^' into field1 field2......

it_tab1-field1 = field1.

it_tab1-field2 = field2.

......

append it_tab1.

Regards

Sandeep Reddy

Re: internal table help

Former Member — Fri, 27 Jun 2008 12:22:58 GMT

Hello

SPLIT f AT g INTO TABLE itab.

Splits f wherever the separator g occurs and places the resulting sections into the fields of internal table itab. The sytsem creates a table row for each section of f.

Note: If f ends with the separator string g, the system does not create an empty table row at the end. This is in contrast to what happens when g occurs at the beginning of f.

Re: internal table help

Former Member — Fri, 27 Jun 2008 12:25:30 GMT

Hi,

Try this-

Data: w_string(100),

w_del type c value '^'.

Data:

begin of wa,

f1(20) ,

end of wa.

Data: itab like table of wa.

w_string = 'A^000001234Griffiths^Timothy ^⁸⁴⁰USNA^{0999CC#0034567841}^^BO098711⁰⁴⁰⁰'

SPLIT w_string at w_del into table itab.

Loop at itab into wa.

Write:/ wa-f1.

Endloop.

Thanks.

Sujit