field fixed length

[Former Member]

What is the difference between field fixed length and field seperator parameters which we use in file content conversion.

I have checked Michael blog "how to send flat file with fixed length in xi 3.0 using a central file adapter".I that he provided a flat file

120 MATNR 3335660

130 MATNR 4445545

and he said Fixed lengths are 10,20,10. I didnt understand what is fixed lenghs 10, 20, 10.

Can anyone help me to understand the concept.

Regards,

Suresh.

[justin_santhanam · Accepted solution]

Suresh,

If you say field fixed length as say 5,4,3 then

INDIA0318100

then the fields will be separated as

INDIA

0318

100

In the above case field Separator is not needed, based on the length the values will get segregated.

raj.

[Former Member]

hai field fixed lengths means the length of the field in the file structure..

you can check the following links for the complete informatin on FCC

File Receiver with Content Conversion

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Configuring the Receiver File/FTP Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

File content conversion sites

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Please see the below links for file content conversion..

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

File Content Conversion for Unequal Number of Columns

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

Content Conversion (Pattern/Random content in input file)

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC - MDM

note:reward points if solution found helpfull.....

regards

chandrakanth.k

[Former Member]

Hi Suresh,

We specify FieldFixedLengths in File content conversion parameter.It means you are specifying a String containing the column widths seperated by commas. In the example you given 10,20,30. It means length of 1st column in text file is 10,2nd is of 20,3rd is of 10 length.specifying the length of the column/field.

and field seperator you specify a character which is the seperator in your flat file.

in this example,

120 MATNR 3335660

130 MATNR 4445545

The fieldseperator you specify is a space character(' ').

Reward points if helpful.

--Sankar Choudhury

[Former Member]

Hey

10 is the fieldlength of first element(i.e 10)

20 is the field length second element(i.e.MATNR)

and 10 is the fieldlength of third element(i.e.3335660)

i know in picture it doesn't looks like 10 characters or 20 characters but thats what it means .

Thanx

Aamir