on 06-27-2016 10:25 PM
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.processConfiguration | FromConfiguration |
Registro.fieldSeparator | 'nl' |
Linha.fieldSeparator | '0x09' |
Linha.endSeparator | 'nl' |
Linha.missingLastFields | Ignore |
Any sugestions how can I resolve this problem, please?
Thanks & regards,
Dalmo
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solved this problem! We removed the last blank line during file creation procedure.
Thanks Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
please try with hexadecimal value of line feed without carriage return
0x0A --> NL line feed, new line
regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.