topic Re: XML space tag problem in XML simple transformation de-serialization in Application Development and Automation Discussions

XML space tag problem in XML simple transformation de-serialization

Rajesh_Amirinen — Sat, 01 Nov 2014 08:09:29 GMT

Dear friends,

I have a problem while converting xml file into internal table (de-serialization) using simple transformation.

there is a tag like <tag> </tag> and I am using condition to check whether tag consist data or not.

because of the space value in the tag I am getting an exception 'CX_ST_COND_CHECK_FAIL' during the condition check.

before deserialization, i am removing empty tags from the xml by using below statement.

REPLACE ALL OCCURRENCES OF REGEX '<\w+/>' IN l_string WITH ''.

but because the tag has the space value it is not getting removed from the XML.

and i am using below code to check is there any tag with empty value. at this condition, because of space value

i am getting the exception 'CX_ST_COND_CHECK_FAIL'.

              <tt:cond check="DENIAL_CODE!=''">

                <DenialCode tt:value-ref="DENIAL_CODE"/>

              </tt:cond>

please advise on this.

Regards,

Rajesh

Former Member — Sun, 02 Nov 2014 10:38:52 GMT

If xml is well formed, below regular expression can be used.

If xml is ill formed, the transformation will fail anyways.

DATA lv_str TYPE string VALUE '<tag1><tag2><tag> </tag><tag>asdf<tag><tag> </tag></tag2><tag1>'.

REPLACE ALL OCCURRENCES OF REGEX '<\w+> </\w+>' IN lv_str WITH ''.

WRITE lv_str.

Rajesh_Amirinen — Sun, 02 Nov 2014 11:38:11 GMT

Thank you Manish,

it seems you code is working fine, but are you sure that it will not delete any other tags.

let me know your comments.

Regards,

Rajesh A.

Former Member — Sun, 02 Nov 2014 11:45:13 GMT

It should work fine for well formed xml. Potentially it will also delete occurrences like <tag> </anothertag> but that is not expected in real xml.

Rajesh_Amirinen — Tue, 11 Nov 2014 07:18:25 GMT

Thank you so much for your help.