topic Re: Split String at delimiter into table. in Application Development and Automation Discussions

Split String at delimiter into table.

former_member202771 — Tue, 06 May 2014 15:14:52 GMT

Hi Experts,

I have a requirement wherein i need to split aaaa#bbbbbbbbbbbb#ccc#dddddddddddddddddddddd#e# into internal table as below:

Header 1	Header 2
1	aaaa
2	bbbbbbbbbbbb
3	ccc
4	dddddddddddddddddddddd
5	e

how can this be done.

Thanks & Regards,

Anil

Re: Split String at delimiter into table.

VijayCR — Tue, 06 May 2014 15:19:15 GMT

Use SPLIT at # command,

thanks,

VJ.

Re: Split String at delimiter into table.

former_member202771 — Tue, 06 May 2014 15:25:38 GMT

Hi,

split at into variables?

Number of # is not a constant here. split into variables and appending to table will not work here.

thanks,

Anil

Re: Split String at delimiter into table.

rosenberg_eitan — Tue, 06 May 2014 15:34:14 GMT

Hi,

ABAP Keyword Documentation

Re: Split String at delimiter into table.

Former Member — Tue, 06 May 2014 15:36:41 GMT

Hi Anil,

Declare one internal table with field string data type.

data : Begin of ty,

var type string,

end of ty.

data it type table of ty.

Then use below syntax,

split <string> at '#' into table it.

Hopes it helps you.

Thanks,

Ashok.

Re: Split String at delimiter into table.

former_member202771 — Tue, 06 May 2014 15:53:42 GMT

Hi Ashok,

split <string> at '#' into table it. -Doesn't work

split <string> at SPACE into table it. - Works

But same statement with '#' is not working.

Feeling strange.

Thanks,

Anil

Re: Split String at delimiter into table.

rosenberg_eitan — Tue, 06 May 2014 15:57:42 GMT

Hi,

It might be a tab .

Try with cl_abap_char_utilities=>horizontal_tab

regards.

Re: Split String at delimiter into table.

former_member202771 — Tue, 06 May 2014 16:01:29 GMT

Hi Eitan,

How do we split on wrt to tab.

# here is a tab, formed when data uploaded from an excel.

Thanks,

Anil

Re: Split String at delimiter into table.

rosenberg_eitan — Tue, 06 May 2014 16:07:03 GMT

SPLIT text AT cl_abap_char_utilities=>horizontal_tab INTO....

Re: Split String at delimiter into table.

former_member202771 — Tue, 06 May 2014 16:09:03 GMT

SPLIT text AT cl_abap_char_utilities=>NEWLINE INTO.... worked beautifully.

Thank you,

Anil

Re: Split String at delimiter into table.

rosenberg_eitan — Tue, 06 May 2014 16:15:09 GMT

You need to look at debug at the hex value.