Skip to Content
author's profile photo
Former Member

endSeparator not working in FCC

Hi,

My requirment is that comma should appear as end separator llike shown below:-

a;b;c;d,

e;f;g;h,

i;j;k;l,

......,

I have used all the possible combination for endSeparator like , ; ',' ; '0x2C' ; ,'nl' ; ',nl' .

But nothing is helping me...I also try with string zzz ; 'zzz' ; 'zzz'nl ; etc...but still zzz is not appearing in the end, am i doing something wrong?...can any help

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Posted on Nov 27, 2008 at 05:01 PM

    Hi,

    Try:

    <RecordsetStructure>.fieldSeparator = ;

    <RecordsetStructure>.endSeparator = ,

    Ex.:

    Record.fieldSeparator ;

    Record.endSeparator ,

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2008 at 04:38 AM

    Hi

    try giving <Data>.endSeparator =','

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 28, 2008 at 04:43 AM

    even nl doesnot work..?

    can u paste ur FCC parameter

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 28, 2008 at 05:22 AM

    Hi,

    Check ur Data type first node. u should use data type starting node while using fieldseparator.

    If ur heirarchy or structure is like this:

    DT_Sender

    DATA

    MATCODE

    MATDESC

    POS

    Ex:DATA.fieldSeparator

    DATA.fieldNames

    DATA.endSeparator

    Edited by: Mahesh Reddy on Nov 28, 2008 10:53 AM

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 28, 2008 at 05:23 AM

    Hi,

    Check ur Data type first node. u should use data type starting node while using fieldseparator.

    If ur heirarchy or structure is like this:

    DT_Sender

    DATA

    MATCODE

    MATDESC

    Ex:DATA.fieldSeparator

    DATA.fieldNames

    DATA.endSeparator

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      My structure look like this:-

      Root

      DT_header --> 1-outbound

      record1 --> 1-1

      record2 --> 1-1

      DT_Tailor --> 1-1

      Dummy --> 1-1

      And my FCC looks like:-

      DT_header.fieldSeparator = ;

      DT_header.endSeparator = I tried , and ',' and '0x2C' etc - nothing is working

      DT_header.fieldNames = recor1,record2

      DT_Tailor.fieldSeparator = ;

      DT_Tailor.fieldNames = Dummy

      Along with this I also tried fieldFixedLengths......still i dont know why endSeparator is not working. Any help will be appreciated and rewarded.

      Edited by: dalprit Sawhney on May 3, 2011 1:56 PM

      Forget to update this message.....just deleted the FCC and recreate the same and it work 😊