Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Sergey. Thanks for your reply.
Have worked around it. Used Excel to copy the file out to a 95 XLS type , and then imported in VFP with Appe from Type XLS
Regards,
Gerard
>AFAIK, that part is not configurable in Excel. You'll have to loop through Excel records/columns and build export file himself.
>
>>I have tried a few different options to output a text file (or CSV) file form Excel (Office 97) , but having a problem with double quotes
>>Some of my data has a double quote at the end to signify an inch)
>>Each time I export, it puts a Doule Quote at the start and end of the text
>>e.g.
>>Pipe3" comes out as ->>> "Pipe3"" (An addiitonal Double Quote before the text and an additional Double quote at the end of the text
>>All I want is the single Double Quote (i.e. to export exactly the data without appending anything (other than a comma to separate the fields)
>>I have tried Csv, Txt, Tab Delimited but in all cases Excel is outputting the additional DoubleQuotes
>>
>rd
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement