on 09-06-2007 5:31 PM
I have the following file format that needs to be converted into XML, but because it has more than one level of substructure I'm not able to give the correct file conversion parameter
source file sample:
1headeryyyyyyyyyyyyy
2itemsyyyyyyyyyyyyyy
2itemsyyyyyyyyyyyyyy
2itemsyyyyyyyyyyyyyy
3trailer1yyyyyyyyyyyyy
4trailer2yyyyyyyyyyyyy
2itemsyyyyyyyyyyyyyy
2itemsyyyyyyyyyyyyyy
2itemsyyyyyyyyyyyyyy
3trailer1yyyyyyyyyyyyy
4trailer2yyyyyyyyyyyyy
Thus you see above that there is one header followed by a bundle that conrains many items and 2 trailers and this bundle can repeat any number of time.
Could anyone let me know how to parse this type of file to XML?
Thanks,
Lakshmi
Hi Lakshmi,
See this blog:
<a href="https://answers.sap.com/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter:///people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter
[]´s
Marcelo Macedo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marcelo,
Those mentioned in the block contains only one level of substring, in my case I need the conversion parameters set such that after ut reads some items, trailer1 and trialer2, it should again pick up items. Currently I have declared the recordset structure as below:
FILE_HEADER,1,ITEMS,*,TRAILER1,1,TRAILER2,1
which reads only one batch of items, trialer1 n trailer2.
Thanks,
Lakshmi
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.