Versions des environnements
Network:
Windows 2008 Server
>There is
>APPEND FROM Command
>which unlike
>IMPORT FROM Command
>assumes we know how many fields in CSV and prepared respective table with the same number of fields.
>Is there known and free piece of code ( e.g. function ) which behaves like Import for CSV. I.e. max of comas per line in a file will be calculated ,
>table with a,b,c,d... max_comas+1 columns created and populated. Seems to be quite common task.
There is the import wizard, which will analyze the selected file after you selected it in the GUI.
I often use a template of memo fields for which the max length is calculated and map later to specific target structure slightly modified.
The totally generic versions won't make use of the similarity encounterd in given files which follow similarity patterns from their source.
If you have a recurring need to read evolving files, rolling your own is best and not that difficult.
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