Receiver File Adapter

[Former Member]

Hey,

My scenario like this... ( file to file)

Source file structure:

DataType :

DT_Source :

Data-->Num1,Num2,Num3

Source file look like : 123456789

Target file structure:

DataType :

DT_Target :

Data-->Num1,Num2,Num3

Target file structure needed: 123 456 789

Note : Simply, I need a separation of one space between three fileds in Target side.

Here, I'm using File content conversion and in Receiver side I did use config params like :

Data.filedFixedlengths : 3,3,3

Data.fieldFieldSeparator:

Data.fieldEndSeparator:'nl'

Still I'm not getting required format, Is there any thing missed on my config part????!!!!

[Former Member]

Xavier,

Try Data.FieldSeparator: 0x20

0x20 is hexadecimal representation of space. Or give space only and check once.

---Satish

[former_member206604]

Hi,

When you are going for fixed lenght why do you need a fieldSeparator in first place. There is no need to field separator, you can go with fixed length and please remove fieldSeparator from your content conversion. Hope the number of characters in the file is always the same.

What is error you are getting when you gave fiexedLenght = 3,3,3? Is it your adapter monitoring fine? Then did you check your SXMB_MONI how are the values placed there is it splited as expected? If all these are fine chekc what is the value after mapping?

Did you add the fieldNames if not please do that.

Regards,

Prakash

[Former Member]

Stallin,

Why dont you try to use Data.filedFixedlengths : 4,4,4 then your issue may resolve.

---Satish

[Former Member]

Try using the hexa decimal representation of "space" in content conversion. Also let us know the output you are getting with this parameters..

Regards,

Jai Shankar.

[Former Member]

Hi

Try using :

structure.fieldSeparator = '0x20'

Regards

Vijaya