Greetings,

I create a cursor and then import from a flat file. The flat file is comma-delimited with all field data surrounded by double quotes.

When I import it, the double quotes are included as part of the data? This should not be happening. I have used this command for decades and I have never seen this before.

Below is the code and the import file example. The cursor looks just like the import file data (with the double quotes).

Any ideas on this one folks?

CREATE CURSOR curPremiereTimeClockProcess ;
	( 	tci_lastname 		C(20), ;
		tci_firstname 		C(20), ;
		tci_SSN 			C(13), ; 
		tci_PersonType		C(10), ;
		tci_TypeAttendance	C(10), ;
		tci_month 			C(10), ;
		tci_day 				C(10), ;
		tci_year 			C(10), ;
		tci_Totalhours 		C(10), ;
		tci_Theoryhours 	C(10), ;
		tci_Clinichours 		C(10), ;
		tci_Practicalhours 	C(10), ;
		tci_UpdatedOn		C(25), ;
		tci_UpdateMessage	C(60), ;
		tci_PermitNumber 	C(10), ; 
		tci_Date				D, ;
		tci_PeoID			I, ;
		tci_SchoolID		I )				

SELECT curPremiereTimeClockProcess
ldFilename = 'PremiereTimeClock.ptc'
APPEND FROM (ldFilename) DELIMITED 

* ALSO TRIED: APPEND FROM (lcFileName) DELIMITED WITH "" WITH CHARACTER ','

"05","03","2011","05","03","2011",“Y”,“N”    
“ALBERTS”,“ALICE”,“223456789”,“S”,“ATTENDED”,"5","3","2011",“8.00”,“3.00”,“3.00”,“2.00”,“”,“”
“DOWNS”,“DONNA”,“323456789”,“S”,“ATTENDED”,"5","3","2011",“6.50”,“1.50”,“3.00”,“2.00”,“”,“”
“JOHNSTON”,“JOANNE”,“423456789”,“S”,“ATTENDED”,"5","3","2011",“8.97”,“3.97”,“3.00”,“2.00”,“”,“”
“MANN”,“MIA”,“523456789”,“S”,“ATTENDED”,"5","3","2011",“7.35”,“2.35”,“3.00”,“2.00”,“”,“”
“ROMERO”,“IRENE”,“123456789”,“S”,“ATTENDED”,"5","3","2011",“7.97”,“2.97”,“3.00”,“2.00”,“”,“”

Thanks!

Scott M.