Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Extracting alpha from messy data
Is there a way to extract (eliminate) all the alpha data from a string that looks like this? they want the numbers, not the letters. Thanks. 63(J) 64(J) 67(J) 35(J) 97(R) xx63(J) xx96(J) 805(K) T32(J) T6(J) 44(J) xx702(J) 45(J) xx11(J)...- wlynch
- Thread
- Replies: 7
- Forum: Microsoft: FoxPro
-
Speeding up this process
There is a faster way to accomplish this but I am not sure where to start. This places an additional line into the primary database and I know how much filters and insert blank will slow the process down. Any ideas? ****************** Set Deleted On Select 1 Use Mydatabase Set Safety Off Set...- wlynch
- Thread
- Replies: 11
- Forum: Microsoft: FoxPro
-
Delimited files
I've read as many posts as I can find to answer the question of how to produce a comma ONLY delimited file with NO quotes but I can't find how to include the header at the same time. COPY TO c:\myfolder\mytextfile.txt DELIMITED WITH "" with CHARACTER , This will work but gives me a file with...- wlynch
- Thread
- Replies: 15
- Forum: Microsoft: FoxPro
