Skip to Content
author's profile photo Former Member
Former Member

Sender file conversion

Hi,

I need to convert a flat file to XML. The problem is that the key field is NOT the first field. It´s the second...

Suppose the file is as follows:

000000010aaaaa

000000120bbbbb111

000000220ccccc111

000000320ddddd111

999999999xxxxx

The first 7 is a kind of a line-numbering. The structure type is defined in position 8-9 (10 = header, 20 0 item and 99 = end)

How do i set up the keyFieldValue??

Regards

Jakob Steen-Petersen

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 12:38 PM

    Hi Steen,

    you would need to specify the name of your key field, xml.keyFieldName, here you can specify the name

    and in xml.keyFieldValue, you can give the value "aaa..." or "bb.." etc

    you would also give the xml.fieldNames & xml.fieldFixedLengths where u specify the order of your fields

    Hope this helps

    Regards

    Vishnu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.