topic Re: Single String into Multiple rows in SAP-ABAP. in Application Development and Automation Discussions

Single String into Multiple rows in SAP-ABAP.

Former Member — Mon, 04 Nov 2013 14:19:27 GMT

HI all,

I need to convert a single string into multiple rows using abap.

"ABC#DEF#GHI" this string has to be converted into

ABC

DEF

GHI

can anyone help me in this.

Thanks,

Vinod.

Re: Single String into Multiple rows in SAP-ABAP.

aferngas — Mon, 04 Nov 2013 14:21:53 GMT

You can use SPLIT statement.

DATA lt_substr TYPE STANDARD TABLE OF string.

SPLIT 'ABC#DEF#GHI' AT '#' INTO TABLE lt_substr.

Cheers,

Alex

Re: Single String into Multiple rows in SAP-ABAP.

Former Member — Mon, 04 Nov 2013 14:29:04 GMT

Hello,

use the following line.

replace all occurrence of '#' IN line with CL_ABAP_CHAR_UTILITIES=>NEWLINE.

By using this CL_ABAP_CHAR_UTILITIES=>NEWLINE , your data will be visible to you in ABC#.. etc format but that # will be symbol of new line. so data will store in DB in ABC#... format and on UI

abc

bcd

format.

** Line, string input.

Re: Single String into Multiple rows in SAP-ABAP.

Former Member — Mon, 04 Nov 2013 14:37:39 GMT

In addition of Alex, Now LT_sunstr will have 3 row 1 will have ABC 2nd DEF and 3rd GHI. now if you want to show them on UI.

** demo code.

loop LT_sunstr to wa. (wa type string)

write wa.

skip.

endloop.

Re: Single String into Multiple rows in SAP-ABAP.

RaymondGiuseppi — Mon, 04 Nov 2013 14:47:03 GMT

First check actual value of # in your string, # can be any non-displayable character, once you are sure, then you may use SPLIT statement.

Regards,

Raymond

Re: Single String into Multiple rows in SAP-ABAP.

Former Member — Mon, 04 Nov 2013 14:57:01 GMT

Can you please elabrate by coding.

Re: Single String into Multiple rows in SAP-ABAP.

Former Member — Mon, 04 Nov 2013 15:01:13 GMT

Can you please elabrate by coding.

Re: Single String into Multiple rows in SAP-ABAP.

Former Member — Mon, 04 Nov 2013 15:08:19 GMT

you need to know 2things in ABAP.

New line character in ABAP ..

Split statement in ABAP... Splitting Character Strings (SAP Library - ABAP Programming (BC-ABA))

Please read both before doing anything.,

Re: Single String into Multiple rows in SAP-ABAP.

RaymondGiuseppi — Mon, 04 Nov 2013 15:29:49 GMT

Would be considered as spoon feeding, (Read the Rules of Engagement)

(And a code for a single statement....)

Regards,

Raymond