Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy to delimited
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00795350
Message ID:
00795370
Vues:
27
If the comma delimited file is the only option, then the only way I see is to get file from the final cursor/temporary table where memofield is converted to character.
Details depend on what is the max length of the memo field. If it is less than 254, then the content of the entire memo field may be converted, otherwise you need to split memofield into several columns.

>Hi Yuri,
>
>Thanks for the information. The question still remains, however, How do I export memo fields to a comma delimited file? Is there some other command that I can use? The person to whom I am sending this information can not read .dbf files with their application. They need a comma delimited file. Is this possible?
>
>Thanks,
>
>
>
>>As in VFP Help on COPY TO:
>>
>>"If the file you are creating is not a table, memo fields are not copied to the new file, even if memo field names are included in the field list"
>>
>>
>>>Hello,
>>>
>>>I have a table with some character fields and some memo fields. I want to put the data in a comma delimited .txt file.
>>>
>>>When I issue the COPY TO test TYPE DELIMITED command, all of the fields EXCEPT the memo fields are exported to the document.
>>>
>>>QUESTION: How do I get the memo fields to export to the document?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform