Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appending from csv files
Message
 
À
17/02/2015 12:26:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01615469
Message ID:
01615489
Vues:
22
>>>>>>>You must use the specific file name. You can use ADIR to get a list of files then loop though the array.
>>>>>>>
>>>>>>>
>>>>>>>>In my directory j:\interlinkhayes are a number of csv files all of the same format delimited with commas
>>>>>>>>
>>>>>>>>If I append just 1 file as follows APPEND FROM j:\interlinkhayes\INT12345.csv DELIMITED WITH CHAR , I have no problems
>>>>>>>>
>>>>>>>>But if I try APPEND FROM j:\interlinkhayes\INT*.csv DELIMITED WITH CHAR , I get errors
>>>>>>>>
>>>>>>>>What is the simplest code for appending multiple files with a skeleton INT*.CSV
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>Can you show me the code to get a list of all the files
>>>>>>
>>>>>>Much appreciated
>>>>>
>>>>>
>>>>>lcDir = ' j:\interlinkhayes\'
>>>>>lcSkeleton = 'int*.csv'
>>>>>lnFiles = adir(laFiles, lcDir + lcSkeleton)
>>>>>for lnX = 1 to lnFiles
>>>>>   append from (lcDir + laFiles(lnX,1) ...
>>>>>Endfor
>>>>
>>>>Sorry no it doesnt work it appends 2 of the same record
>>>
>>>Probably because your files contains some identical records?
>>
>>Sorry I meant my solution contains 2 of the same record - I cant get yours to work at all - what am I doing wrong?
>
>I do spot one error in my code. Inside the loop, I forgot one ')'. Try "append from (lcDir + laFiles(lnX,1)) DELIMITED WITH CHAR , "

lnfiles returns 0 from your code
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform