on 12-14-2007 10:17 AM
Hi All,
I am doing FCC on a file where records are seoparated with , and the last record is seperated with # so Iam giving fieldSeparator as ',' and endsepartor as '#' but the end separator is not working and it is failing saying that csv file contains more fields than specified .
However when I am giving single record I am able to run the same.
Also multiple records with End separator as 'nl' is working but I ahve to change the file replacing '#' with 'nl'
I amnot able to solve this problem urgent help is required
regards
Amit,
<b><saying that csv file contains more fields than specified></b>
In you FCC <b>"#"</b> is treated as a field, you have to give the endSeparator as 'nl'.
Regards,
Sarvesh
Message was edited by:
Sarvesh Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sarvesh ,I tried this also but not working .
My file structure is like this :
276,2/1/2007,10:48:36,Access-granted,203,12,02-02-Recpection-Exit,5,PRAMOD-KUMAR-RAJARAYA,65:00120l$277,2/1/2007,10:49:04,Access-granted,203,12,01-02-Recpection-Entrance,5,SANDEEPIKA-SEHGAL,65:00140N$
And my parameters are like this :
Record.fieldNames =Sequence,Date,Time,EventMessage,EventNumber,Obj1,ObjDesc1,Obj2,EmpName,CardNumber
Record.fieldSeparator=,
Record.endSeparator =$
Regards
did u try giving in single quotes or double quotes?
it looks like it is not taking the '#'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think '#' would be present in your data....
try '$' instead of '#'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.