Skip to Content
author's profile photo Former Member
Former Member

Receiver File Adapter

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????!!!!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 12:42 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 12:43 PM

    Stallin,

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

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 12:51 PM

    Xavier,

    Try Data.FieldSeparator: 0x20

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

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.