Skip to Content
0
Former Member
Jan 29, 2009 at 09:13 AM

System not recognising the ~ as separator in txt file.

55 Views

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.