on 11-27-2008 3:20 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
even nl doesnot work..?
can u paste ur FCC parameter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
try giving <Data>.endSeparator =','
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try:
<RecordsetStructure>.fieldSeparator = ;
<RecordsetStructure>.endSeparator = ,
Ex.:
Record.fieldSeparator ;
Record.endSeparator ,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.