topic Issue with simple transformation code in Application Development and Automation Discussions

Issue with simple transformation code

former_member745949 — Sun, 30 Mar 2014 06:56:15 GMT

Hi Folks

I am working on developing a custom simple transformation, the requirement is convert the upload the file(unknown columns text file) into xml code.

here columns text has not been mentioned so while uploading this data using "upload" function module we can get into string table, so now I want to pass this data into transformation to convert into below format, can you please suggest me how can I do this.

<Name>first 10 characters in the file line1</Name>

<Address>character 11 to 40 in the file line1</Address>

<Salar>character 41 to 50 in the file line1</Salary>

Etc.,

</Template1>

Please suggest me how to split the file line 1 data based on my tags in the simple transformation.

Appreciate your help on this.

Regards,

Naresh.

Re: Issue with simple transformation code

matt — Sun, 30 Mar 2014 07:10:52 GMT

The simplest way is to convert your data first into an internal table with fields for name, address, salary etc.

Then use:

DATA my_output_xml TYPE string.

CALL TRANSFORMATION id RESULT xml my_output_xml SOURCE data = internal_table.

Re: Issue with simple transformation code

former_member745949 — Tue, 01 Apr 2014 23:09:19 GMT

Hi Matthrew,

I was also thinking on this simple solution.

If I could make the entirething(spliting xml into internal table and convert them into xml tags format) with in the transformation so that I don't need to make any changes in the program side.

I hope I need to get expertise on this xml so that I can wrote my own code.

Anyhow thanks for your reply on this.

Regards,

naresh.

Re: Issue with simple transformation code

Former Member — Mon, 07 Apr 2014 07:18:44 GMT

Have a look at this snippet.

Substring function is used with offset/length to extract the substring , which is then populated into xml node.

ABAP code

DATA: lt TYPE TABLE OF string,
      xml TYPE string.
APPEND '112123123412345' TO lt.
APPEND '445456456745678' TO lt.
CALL TRANSFORMATION ztest
  SOURCE lt = lt
  RESULT XML xml.
cl_abap_browser=>show_xml( xml ).

XSLT code


<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:sap="http://www.sap.com/sapxsl" version="1.0">

  <xsl:strip-space elements="*"/>

  <xsl:template match="/">
    <root>
      <xsl:apply-templates select="//*/item"/>
    </root>
  </xsl:template>
  <xsl:template match="item">
    <Template1>
      <one>
        <xsl:value-of select="substring(concat(., ''), 1, 1)"/>
      </one>
      <two>
        <xsl:value-of select="substring(concat(., ''), 2, 2)"/>
      </two>
      <three>
        <xsl:value-of select="substring(concat(., ''), 4, 3)"/>
      </three>
      <four>
        <xsl:value-of select="substring(concat(., ''), 7, 4)"/>
      </four>
      <five>
        <xsl:value-of select="substring(concat(., ''), 11, 5)"/>
      </five>
    </Template1>
  </xsl:template>

</xsl:transform>

Output xml


<?xml version="1.0" encoding="utf-8" ?> 
 <root>
   <Template1>
     <one>1</one> 
     <two>12</two> 
     <three>123</three> 
     <four>1234</four> 
     <five>12345</five> 
   </Template1>
   <Template1>
     <one>4</one> 
     <two>45</two> 
     <three>456</three> 
     <four>4567</four> 
     <five>45678</five> 
   </Template1>
 </root>

Re: Issue with simple transformation code

former_member745949 — Mon, 07 Apr 2014 22:06:06 GMT

Hi Manish,

You are right!, thanks.

Regards,

Naresh.