topic Re: Find a variable length string between two strings in Application Development and Automation Discussions

Find a variable length string between two strings

Former Member — Fri, 03 Jun 2016 14:35:14 GMT

HI Experts,

I have a requirement where i have to fetch a sub-string of variable length between two substring in a string.

I have a string like this:

<MOABETR>amount</MOABETR>.

i need to fetch value of amount and length of amount can vary. Is there any way to do that?

IF i search for occurrence of <MOABETR> and get the offset and i add the length of it to that offset and start fetching value from there, i wouldn't be sure; how many characters to fetch because length of amount varies.

Thanks,

Dheeraj

Re: Find a variable length string between two strings

Former Member — Fri, 03 Jun 2016 14:53:55 GMT

As the tags are XML alike, you could try this:

Execute function module SCMS_STRING_TO_XSTRING with importing parameter TEXT = <MOABETR>amount</MOABETR>.

The restult will be in the exporting parameter buffer.

execute function module SMUM_XML_PARSE and use the buffer as input for XML_INPUT.

the table XML_TABLE will have what you need 🙂

Re: Find a variable length string between two strings

ThomasKruegl — Mon, 06 Jun 2016 08:58:01 GMT

You could search for occurrence of </MOABETR> too, and then combine the values to get the correct start and length.

kind regards,

Thomas

Re: Find a variable length string between two strings

pranay570708 — Mon, 06 Jun 2016 09:13:34 GMT

Hi,

Check this example:

DATA: L_STRING TYPE STRING VALUE '<MOABETR>1234567890</MOABETR>',

L_OUT TYPE STRING,

L_LEN TYPE I.

REPLACE ALL OCCURRENCES OF REGEX '[A-Z]' IN L_STRING WITH SPACE .

L_LEN = STRLEN( L_STRING ) - 5.

L_OUT = L_STRING+2(L_LEN).

WRITE: L_out.

Re: Find a variable length string between two strings

Former Member — Mon, 06 Jun 2016 09:20:34 GMT

Hello All,

Thanks for your response but that string could be repeated as well. Glenn's answer seems best.