Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export to an ASCII file with tabs without Quotes
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00978865
Message ID:
00979219
Vues:
22
Dave,
thanks for the input. I used the space only becuase it was ignored by the program that read the file. It worked but with files over 12MB, removing the spaces makes a 10% or better difference when sending them over the "wire".

I have a question. How do you format your code examples in HTML???? Being an old DOS guy I feel like I missed the bus somewhere.
TIA

>John,
>
>There is no difference between the kinds of quotes used... the problem was the space you put between them. *g*
>
>
>* BAD:
>copy to o:\apinvcln.txt deli with ' ' (1 space) with tab.
>
>* GOOD:
>copy to o:\apinvcln.txt deli with '' with tab
>copy to o:\apinvcln.txt deli with "" with tab
>copy to o:\apinvcln.txt deli with [] with tab
>
>
>>thanks, it worked! This is the first time I have ever seen a difference between the single and double quotes. I had not tried the double quote assuming it would be the same result.
>
>>>No space.
copy to o:\apinvcln.txt deli with ""  with tab
>>>>I can't seem to get the copy to delimeted to export a VFP table without some kind of marker on each side of each field. Currently I am using this command:
>>>>
>>>>copy to o:\apinvcln.txt deli with ' ' (1 space) with tab.
>>>>
>>>>This works ok but encloses each field with spaces. If I use the empty '' I get the ' on each side of the field.
>>>>I tried BLANK in place of the space but I get a syntax error.
>>>>
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform