on 08-20-2010 10:57 PM
In Receiver file adapter, I specified file content conversion parameters. My file structure is as below:
Header
Field1 10
Field2 20
Field3 8
Filler 20
Detail
Field1 10
Field2 8
Filler 8
In both Header and Details structures I have to fill 20 and 8 spaces at end of each line. In XML (Payload) I can view the spaces. But when the text file is created all the spaces are truncated.
Could you please solve this issue.
Regards
Hello,
Can you try by using endSeparator as space and beginSeparator as 'nl'.
Hope this works!
Regards,
Anand Patil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
could you post your FCC parameters to see if they are correct?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Recordset Structure: ns1:MT_SAP,REC,Header,Detail
ns1:MT_SAP.fieldSeparator '0'
ns1:MT_SAP_PNC_PPAY.fieldContentFormatting nothing
REC.fieldContentFormatting nothing
REC.fieldSeparator '0'
REC.processConfiguration FromConfiguration
Header.fieldFixedLengths 10,20,8,20
Header.endSeparator 'nl'
Header.fixedLengthTooShortHandling Ignore
Header.fieldNames Field1,Field2,Field3,Filler
Header.fieldContentFormatting nothing
Detail.fieldFixedLengths 10,8,8
Detail.endSeparator 'nl'
Detail.fieldNames Field1,Field2,Filler
Detail.fieldContentFormatting nothing
Detail.fixedLengthTooShortHandling Ignore
Recordset Structure: REC,1,Header,1,Detail*
Header.fieldFixedLengths 10,20,8,20
Header.endSeparator 'nl'
Header.fixedLengthTooShortHandling Ignore
Header.fieldNames Field1,Field2,Field3,Filler
Header.fieldContentFormatting nothing
Detail.fieldFixedLengths 10,8,8
Detail.endSeparator 'nl'
Detail.fieldNames Field1,Field2,Filler
Detail.fieldContentFormatting nothing
Detail.fixedLengthTooShortHandling Ignore
Try above configuration..
Hi Sai,
As the length of the fields has been fixed,so use the parameter NameA.fixedLengthTooShortHandling
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Add the below parameters in your FCC and then try.
Header.fieldContentFormatting = nothing
Detail.fieldContentFormatting = nothing
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just one suggestion.
Header
Make Field3 length as : 28
Detail
Make Field 2 lengh as : 16
then try to see if it is creating those spaces in your text file or not.
Thanks,
Hetal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sai,
It depends on what editor you are using. Some editors won't show the spaces. I am not sure, but I guess textpad might be able to show blank spaces, try that once.
Regards,
Neetesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.