on 11-28-2005 3:03 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Peter
How about using space instead of an empty string, you can do that passing the values as,
xml.fieldSeparator='0x20'
cheers
Sameer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.