Search results for query: *

What would be good is if the client did'nt insist on using such crazy data in the first place. Thanks to you all. The code does help.

I think that is what I am after Olaf. I'll have to play around with it this morning. The entire file has lots of different letters in it and this looks like a winner. Thanks. Will

Thanks. I'll look and see if I can figure something out. WL

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)...

Interesting stuff. I am working on the suggestion. To answer one question, I don't care if the inserted record is first or second in order. The index idea sounds like a winner JRB. Mike and Olaf, you two always seem to have an answer. Again, thanks to you all!

Cool Mike! Ok, are the fields: Field Field Name Type Width Dec Index...

Thanks!! I'll have to study all this. To answer your question DSumm, "Why would you want to have duplicate records with only the 'fullname' field being different?" That is intentional. The DO NOT MAIL record is a QC piece that is pulled off the production line at the end of each pallet when...

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...

Thanks Olaf-- you are correct, our files are many times in excess of 1MM or more records. The records need to go out to an inkjet machine in single delimiter format for some odd reason. Actually, any delimiter would work but no closing quotes can be present. I always check for imbedded commas...

Ahh.. since I found a way to produce that the program outputting the original dbf file will add the header as the first record, it turned out all I had to worry about was producing a comma delimited file, hence I ended up not needing that small snippet you suggested. Thanks Olaf!

Sure, no problem. Here is what I used CLOSE ALL CLEAR ALL lcFieldString = '' lcMemo = '' USE GETFILE('dbf', 'Select DBF') && Prompts for table to be used. lnFieldCount = AFIELDS(laGetFields) && Builds array of fields from the && selected table. *!* Prompt...

Got it!! All your suggestions and a bit of fiddling around did the trick. Still, sure would be nice if you could just copy to.... etc, etc. and get what you want. LOL Thanks to you all.

The link you gave me worked great for creation of a file with comma and no quotes. Unfortunetly it does not include the header record. I appreciate the effort.

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...