Naomi,
That's it! Thank you...it must be these 13 hours days I'm putting in...I missed it.
Thanks again!
Scott
P.S. Ditto to you Sergey!!!
>Scot,
>
>May be because the quotes not the real quotes, but different kind of double quotes (the ones used in Word).
>
>>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.
