Skip to Content
avatar image
Former Member

File length in File Content Conversion

Dear All,

I have developed an Integration Process (IDOC to Fixed Field Length).

Total length - 56

Breakup for each field - 5, 1, 14, 1, 5, 1, 14, 1, 5, 1, 8 (Total - 56 characters)

The file is getting created successfully but it is showing a length of 57 character.

But if I create the file manually then it is showing 56 characters.

I tried removing the last line 'endSeparator', but it is still showing 57 character length.

Please suggest

Regards,

Rana Brata De

FCC.jpg (15.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 18, 2012 at 10:13 AM

    Hi Rana,

    Can you try with Controls.endSeparator asĀ  '0'

    Add comment
    10|10000 characters needed characters exceeded

    • Please have only these parameters in FCC and give a try.

      Header.fieldFixedLengths: mention length

      Header.fixedLengthTooShortHandling: Cut

      Rows.fieldSeparator: 'nl'

      If your source has 2 Rows like


      Row1

      Field1: A

      Field2: B

      Row2

      Field1: C

      Field2: D

      Then your output for Rows will be

      A

      B

      C

      D

      If still you have to maintain the length as 94 for Field1 and Field2, do that in graphical mapping.

  • Jul 18, 2012 at 10:11 AM

    Hi,

    open the file in notepad ++ (http://notepad-plus-plus.org/)

    to be able to see what is the last char (which is not visible in standard notepad) and compare with the one created manually

    this way you will know what's wrong I hope,

    Regards,

    Michal Krawczyk

    Add comment
    10|10000 characters needed characters exceeded