Skip to Content
0
Former Member
Jan 27, 2009 at 03:06 PM

File Sender Content Conversion: Help needed

21 Views

Hello Experts,

i need help with file sender content conversion:

i have a file which looks like this:

12329460  24.01.09/07:01  167     Y010122851  136086  43300007            E70115  1L2_96_1
12329660  25.01.09/07:02  157     Y010122851  136086  43390007            E711J5  1L2_96_1

as you can see 8 fields, separated with whitespaces

and i want and xml file which looks like this:

<DT_DATA_FILESENDER>
  <Recordset>
      <Data>  
        <field1>12329460</field1>
        <field2>24.01.09/07:01</field2>
        <field3>167</field3>     
        <field4>Y010122851</field4>  
        <field5>136086</field5>  
        <field6>43300007</field6>
        <field7>E70115</field7>  
        <field8>1L2_96_1</field8
     </Data>

      <Data>  
        <field1>12329660</field1>
        <field2>25.01.09/07:02</field2>
        <field3>157</field3>     
        <field4>Y010122851</field4>  
        <field5>136086</field5>  
        <field6>43390007</field6>
        <field7>E711J5</field7>  
        <field8>1L2_96_1</field8
     </Data>
  </Recordset>
      

Would you please let me know how the datatype has to look like?

And especially how the FCC has to be configured for this scenario?

Thanks in advance,

Chris