cvv number ('Q','C') , card number , Id
get writes in one cell.
cvv number ('Q'
as a single field..???
cvv number ('Q','C')
Raza Mohd wrote:I am writing a file with .csv extension and file is Excel Comma Saperated Values File.
Raza Mohd wrote:But getting quote when i open it anywhere that i do not need to have.
How could it be handle?
Quotes appear around field when i open it in notepad.
Lester Burnham wrote:If it still doesn't work, post the code you're now using and the file it creates.
Raza Mohd wrote:it worked .
Raza Mohd wrote:and the file it generate is Excel File
Agr no,Receipt No.,Channel,AgencyID,Cheque Number,Dealing Bank Id (=1 if null),Drawn On,Towards,Receipt Amount,Received Date (Cheque sent Date in database),Cheque Date (Receipt Date in database),"Receipt Type ('Q',,'C',,'D') ('Q' if null)",CR. Note number (CRNNUM),"Cheque Status ('R',,'D',,'C') ('C' if null)","Auto Alloc ('Y',,'N') ('N' if null)",EMI Amount,LPP Amount,BCC Amount,Excess Amount,OTHCHARGE1,OTHAMT1,OTHCHARGE2,OTHAMT2,OTHCHARGE3,OTHAMT3,OTHCHARGE4,OTHAMT4,Remarks,Payable At,IT DOC,Paid by,PAN NO,Purpose
011025288000,CP0000009021,,,CP0000009021,13392-PDK,ICICI BANK LTD,Call to Pay payment received,900.0,05/08/2010,05/08/2010,Q,,C,Y,900.0,,,,,,,,,,,,,MUMBAI,,,,NORMAL
011025288055,CP0000073428,,,CP0000073428,13392-PDK,ICICI BANK LTD,Call to Pay payment received,6017.0,05/08/2010,05/08/2010,Q,,C,Y,6017.0,,,,,,,,,,,,,MUMBAI,,,,NORMAL