System not recognising the ~ as separator in txt file.

[Former Member]

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

One_twothree_fourfive

six_seveneight_niniten

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>One_twothree_fourfive</field1>

</item>

<item>

<field1>six_seveneight_niniten>

</item></Data>

.......

Can anyone tell me where I am doing wrong and how can we overcome this.

Thanks in advance

Balaji.

[Former Member · Accepted solution]

specify fieldSeparator = '0x7E' in content conversion parameter for '~'

[Former Member · Accepted solution]

Thanks for your reply...

Its working for me, I have one more question.

In recever system I have give tab '0x09' as the file separator but I am getting the same file in recever side also.

One_twothree_fourfive

six_seveneight_nineten

In recevier side the field separator in not working.

Can you please tell me where I am doing wrong.

thanks in advance.

Balaji.

[Former Member]

Just Mention ~ without any Quotes