cancel
Showing results for 
Search instead for 
Did you mean: 

Blank line at the end of TXT file

Former Member
0 Kudos

Hi Experts,

I created a new interface which transfer TXT files, but at the end of file there is an extra line. I need create files ECC to PI without this Blank Line. I configured my Content Conversion with follow parameters:

Record Structure: Registro, Linha

Linha.processConfigurationFromConfiguration
Registro.fieldSeparator        'nl'
Linha.fieldSeparator        '0x09'
Linha.endSeparator        'nl'
Linha.missingLastFields        Ignore

Any sugestions how can I resolve this problem, please?

Thanks & regards,

Dalmo

Accepted Solutions (1)

Accepted Solutions (1)

former_member190293
Active Contributor
0 Kudos

Hi D.!

While using FCC in your file adapter you only have the option to skip some lines from the beginning of file, not at the end.

So, there are few ways you can go with your requirement.

First, create empty node for blank line and ignore it in further mapping.

Second, develop adapter module which will read your file and compose xml document from it where you could skip blank lines with java code.

Third (and the most preferrable), ask the source system programmers team to remove/not to create the last blank line during file creation procedure.

Regards, Evgeniy.

Answers (2)

Answers (2)

Former Member
0 Kudos

Solved this problem! We removed the last blank line during file creation procedure.

Thanks Evgeniy.

Harish
Active Contributor
0 Kudos

Hi,

please try with hexadecimal value of line feed without carriage return

0x0A     --> NL line feed, new line


regards,

Harish