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

JMS module conversion - xml.fieldSeparator as empty

Hi.

Is it possible to have xml.fieldSeparator as an empty string ai. making the fieldseperator equals to nothing?

The reason for this is that im making a file with fixedlength records. All fields are populated in the mapping.

I know about xml.fieldFixedLengths, but my structure is so complex that I have no idea on how to use this, and also it is alot of extra work if I could just use an empty fieldseperator!

Regards Peter

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2005 at 06:20 PM

    Hi Peter

    How about using space instead of an empty string, you can do that passing the values as,

    xml.fieldSeparator='0x20'

    cheers

    Sameer

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vishnu.

      You where right. It didnt work, but not because of field lengths. The adapter sure enough put in the null character, but it corrupts the file. In most text editors I've opened the result file, the character is interpretated into a space.

      It seems like I have to go for the xml.fieldFixedLengths and try to figure out how this works with multible substructures 😔

      Alot of work that could have been spared if you where able to insert an empty character as a fieldseperator.

      Thanx for the help anyway!

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2005 at 06:28 PM

    Hi Peter,

    check this as well, '0x00' (with quotes). even if u pass such separators, I doubt if you get the desired result. Imagine if the values are not having the expected size of the field.

    for ex. if the expected field size is 10 and if the size of the actual value is 4.

    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.