Hi,
In File2File senario, Sender system is placing txt file with 5 fields in the FTP server as mentioned below,
I have given "~" as fieldseparator and 'nl' as new line.
Fielsender.txt
Onetwothreefourfive
sixseveneightniniten
I have done all the Design and configuration in the XI.
In datatype defination I have given below structure.
File_MT
Data
ITEM
Field1 xsd:string
Field2 xsd:string
..
Field5 xsd:string
Problem: While executing this in Request payloads, the entire row ita taking into Field1 and its not
recnizing the ~ as separator.
Ex: <xml>...
<Data>
<item>
<field1>Onetwothreefourfive</field1>
</item>
<item>
<field1>sixseveneightniniten>
</item></Data>
.......
Can anyone tell me where I am doing wrong and how can we overcome this.
Thanks in advance
Balaji.