Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From difficulties
Message
 
 
To
27/07/2005 11:31:54
Scott Sherman
Puyallup Tribal Health Authority
Tacoma, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01036240
Message ID:
01036265
Views:
9
>There are a couple for tabs and the street address should drop into field 5 but actually drops into field 4. If I remove the double quotes, the field drop in correctly. Also if I replace all of the double tabs with tab.tab, the append correctly as well. This happens in FoxPro 5, 6, 7 and 8.
>
>
>STRTOFILE([SS]+CHR(9)+CHR(9)+[Lori N]+CHR(9)+CHR(9)+["12 13th Pl, #236"]+CHR(9)+[Redmond]+CHR(9)+[WA]+CHR(9)+[98052]+CHR(9)+[SoSi],"c:\test.txt")
>CREATE CURSOR cTest (Fld1 C(50),Fld2 C(50),Fld3 C(50),Fld4 C(50),Fld5 C(50),Fld6 C(50),Fld7 C(50),Fld8 C(50),Fld9 C(50))
>APPEND FROM c:\test.txt TYPE DELIMITED WITH " WITH CHARACTER TAB
>BROWSE NORMAL
>
You can do
APPEND FROM c:\test.txt TYPE DELIMITED WITH | WITH CHARACTER TAB
* VFP8 and later
APPEND FROM c:\test.txt TYPE DELIMITED WITH "" WITH CHARACTER TAB
After that you can post process data to remove double quotes
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform