cancel
Showing results for 
Search instead for 
Did you mean: 

FCC endseparator problem ?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Sarvesh,

Any other solution because I have a file with almost 60000 records not possible to put 'nl' and also its not proper I can't ask client to do the same for obvious reasons

Regards

Former Member
0 Kudos

Hi,

Just try out with lastFieldsOptional ---YES

Hope this might help.

Rgds,

Kumar

Former Member
0 Kudos

no its not working ..

Regards

Former Member
0 Kudos

Amit,

Whatever I have written is to <b>use in FCC only</b> not in your file. I am not saying to make any change in you file or ask client to do so.

Use:

<b>Item.endSeparator '0x0D''0x0A'

Item.lastFieldsOptional YES</b>

Regards,

Sarvesh

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi guys ,

Any updates on this .

Regards

nisarkhan_n
Active Contributor
0 Kudos

did u try giving in single quotes or double quotes?

it looks like it is not taking the '#'

Former Member
0 Kudos

Hi Nisar ,

I am giving it without any quotes and also I have tried the ASCII value also with single quotes but both failed

Any other reason ?

Regards

GabrielSagaya
Active Contributor
0 Kudos

I think '#' would be present in your data....

try '$' instead of '#'