Pat, > Yes ... We wrote a procedure to import csv files. My point was that you can't > just use the basic 4D Import option to import such files.
We don’t use 4D’s import, so I can’t comment on whether it works correctly or not. Chip, > >> the problem I have found with csv is that different software creates >> different formats. >> sometimes, everything is quoted, sometimes only certain values are quoted, >> and similar to the problem of a tab delimited text file, if the text >> contains a equation mark(s) everything gets screwed. The exporting software is supposed to enclose strings and text inside “. The importing software is supposed to be able to handle anything in a string or text cell, provided it is inside the enclosing ". Agreed - sometimes Excel does not follow the cvs rules properly when it exports. But what should we expect? It’s not like they’re a large company with multiple programmers at their disposal… bless their little cotton socks! Cheers, Keith There are 3 kinds of mathematician. Those who can count, and those who can't. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
