Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from keeps the double quotes - why?
Message
 
 
To
05/05/2011 20:48:41
Scott Malinowski
Arizona Fox Software LLC
Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01509769
Message ID:
01509771
Views:
61
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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform