Split String at delimiter into table.

[former_member202771]

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

[VijayCR]

Use SPLIT at # command,

thanks,

VJ.

[former_member202771]

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

[rosenberg_eitan]

Hi,

ABAP Keyword Documentation

[Former Member]

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.

[former_member202771]

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

[rosenberg_eitan]

Hi,

It might be a tab .

Try with cl_abap_char_utilities=>horizontal_tab

regards.

[former_member202771]

Hi Eitan,

How do we split on wrt to tab.

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

Thanks,

Anil

[rosenberg_eitan]

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

[former_member202771]

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

Thank you,

Anil

[rosenberg_eitan]

You need to look at debug at the hex value.