I have an import method that I have used many times through 16 and a couple in 17 (but not 17.3).
The export of the data from 4D 6.8 is all records, with all fields just standard 4D fields (no pictures etc). It is set as a Macintosh File format. I have looked at the exported file in BBEdit and each line looks good. There is a carriage return at the end of each line. There are some accented characters that are in the data, but this did not cause any problems before. In 4D 17.3 I have an import method. The first thing I do though, is look through the selected disk base file and count the number of carriage returns. This tells me how many lines (records) there are in the text file. There should be 11,960 lines counted. When I had used ‘Use Character Set’ (US_ASCII”;1) in the past it always worked just fine. Now the method cannot find a Carriage return after the 6th line. I noticed that in the 6th line there was a á character. To just try it, I switched ‘Use Character Set’ to (UTF-8;1) This time it gets to 347 lines (in all attempts). This seems like a stupid programmer - smack front of head - mistake that I am making. Therefore in taking a pause on tackling this problem - any ideas? Thanks Jody Bevan ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
