Skip to Content
author's profile photo Former Member
Former Member

Key field value changes: Field Content conversion: FCC

HI All,

I am in the File to IDOC scenario using FCC.

The first line of my csv file (HEADER), the value of the key field is 'SOURCE '. i.e 6 characters and 4 spaces.

So in my FCC parameters when I use the value

Header.keyFieldValue = 'SOURCE' OR 
Header.keyFieldValue = 'SOURCE    '.

It does not recognise and hence does not read the header line.

In the incoming file if I strictly use the word 'SOURCE' without any spaces then it works and picks the header field.

Is there a way I can use a wild card character like * or % to let FCC pick up the header record even if it comes with padded spaces.

Apprecitae your response on same.

Thanks

Shirin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jul 30, 2008 at 03:16 PM

    Hi,

    Try representing the SPACE using the ASCII code 0x20 in the FCC.

    Thanks

    SaNv...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 05:54 AM

    in content conversion try with:

    Header.keyFieldValue = SOURCE // SOURCE with 4 space

    Header.fieldContentFormatting = nothing

    Regards...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 07:09 AM

    Header.fieldContentFormatting - nothing .. so that it will not ignore white spaces,

    Header.keyFieldValue = SOURCE ... don't write spaces

    Also make sure in Header.fieldFixedLengths, first length should be 10(6 char for source + 4 white spaces)..

    Header.fieldFixedLengths = 10,....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.