cancel
Showing results for 
Search instead for 
Did you mean: 

White lines generated in a txt File when using variable substitution

Former Member
0 Kudos

Hello,

I have a problem with a File generated by XI, my File Adapter is using variable substitution with reference to a field of my message type. I use content conversion as well and the generated file has a white line in top of file.

How could I avoid this and make the white lines disappear? I was trying a lot of things but I don’t really know how to solve this issue, the following is the data type used:

<FILE_NAME></FILE_NAME>

<COMPANY>

<COMPANY_CODE></COMPANY_CODE>

<COMPANY_NAME></COMPANY_NAME>

<ADRESS></ADRESS>

…….

</COMPANY>

FILE_NAME is the field I use for variable substitution and COMPANY is declare as 0..unbounded.

Thanks a lot in advanced,

Luis

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184543
Active Participant
0 Kudos

Hi,

What all values have you mentioned in the Content Conversion Parameters?

thanks

Anju

Former Member
0 Kudos

Hi Anju,

I have mentioned the following parameters in the content conversion:

COMPANY.fieldFixedLengths 10,80,10,2,50,30,5,5,2,50,50

COMPANY.addHeaderLine 0

COMPANY.endSeparator 'nl'

I have tried as well to enter some parameters for file_name but nothing works out.

Regards,

Luis

Former Member
0 Kudos

First declare length of the field as <b>0</b>.

Use the parameter

<b>fixedLengthTooShortHandling</b>

with value <b>cut</b>.

Regards,

Jai Shankar

Former Member
0 Kudos

Hi Jai,

where should i declare the length of the field as 0??

Regards,

Luis

Former Member
0 Kudos

>>where should i declare the length of the field as 0??

File Content Conversion parameters. Declare the length of the field FILENAME as 0. There is a SDN blog regarding the same written by Sravya illustrating the same concept. Just do a search, you will find it.

Regards,

Jai Shankar

Former Member
0 Kudos

Hi Jai,

I have declare the following Content Conversion parameters:

Recordset Structure: COMPANY

FILE_NAME.fieldFixedLengths 0

FILE_NAME.fixedLengthTooShortHandling cut

COMPANY.fieldFixedLengths 10,80,10,2,50,30,5,5,2,50,50

COMPANY.addHeaderLine 0

COMPANY.endSeparator 'nl'

But it does not work, I have the same white line in the beginning of the file. Do you have any other suggestion??

I couldnt find the blog written by Sravya either, could you post the link?

Thanks a lot,

Luis