Skip to Content
avatar image
Former Member

Sender File Adapter-Content conversion for a tab delimited file

Hi all,

I have a FIle to IDoc scenario, where the File is with the structure Header,Detail,Trailer.

Header and Trailer are with fixed field lengths, whereas the detail records are tab delimited.(Functional spec says delimited by H'05').

I have given the parameters as follows:

Header.keyFieldValue H

Header.fieldFixedLengths 1,1,4,1,8

Header.fieldNames a,b,c,d,e

Header.endSeparator 'nl'

Detail.fieldNames a,b,c,d,e,f

Detail.fieldSeparator '0h05'

Detail.keyFieldValue LOA

Detail.endSeparator 'nl'

Trailer.fieldFixedLengths 1,1,8

Trailer.fieldNames a,b,c

Trailer.keyFieldValue T

ignoreRecordsetName true

In SXMB_MONI, I get the payload with just the Header and Trailer and not the detail records, even though my file has so many records in it.I m pretty sure, this happens because of my Detail.fieldSeparator parameter.

Can anyone please help me with this?What is the correct value for this parameter?

Thanks a lot in advance!

Anjana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 10, 2011 at 05:38 PM

    You have to use 0x09 for TAB. You can see the example of TAB delimited file in this blog..

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sarvesh,

      Thanks for the blog link.'0x09' did not work for me.But copying the tab from a notepad and pasting it at the parameters worked!

      Thanks a lot for the help!

      Anjana.

  • Feb 10, 2011 at 05:55 PM

    >>>Detail.fieldSeparator '0h05'

    Detail.fieldSeparator = '0x09' (tab delimited)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Make sure your detail record structure is having 0..unbounded occurrence. If possible provide the whole FCC parameters here..

  • Feb 10, 2011 at 05:43 PM

    first of all make sure with a hex editor that the hex code of the delimiter sign is really 05. This is an odd character, as the normal tab is hex 09.

    when you have confimred it, check online help for file adapter config for the correct entry of hex codes. I think it is something like '0x05',

    Edited by: Stefan Grube on Feb 10, 2011 6:43 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2011 at 06:12 PM

    Thanks for the help!!

    Add comment
    10|10000 characters needed characters exceeded