cancel
Showing results for 
Search instead for 
Did you mean: 

endSeparator not working in FCC

dalpritsawhne
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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

dalpritsawhne
Explorer
0 Kudos

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.

dalpritsawhne
Explorer
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

even nl doesnot work..?

can u paste ur FCC parameter

dharamveer_gaur2
Active Contributor
0 Kudos

Hi

try giving <Data>.endSeparator =','

pedro_baroni3
Active Contributor
0 Kudos

Hi,

Try:

<RecordsetStructure>.fieldSeparator = ;

<RecordsetStructure>.endSeparator = ,

Ex.:

Record.fieldSeparator ;

Record.endSeparator ,