Just to follow-up on this, I revisited the FileIO UDF that I had written some time ago. I found that I had used Lonk's "build a delimited string and split" method. I had been planning on updating it to use a stepped-dynamic array method and finally got around to it today.
To compare the performance of the old and new methods, I created a simple text file of about 380KB, with just under 5000 lines. The old "build & split" method took 28.157 seconds to load this file into the array and resulted in an array with an extra, empty element. Using the newer "Stepped-dynamic" method that Christophe illustrated above (with a base/increment of 500 elements), loading the same file took a whopping 0.125 seconds (yes, an eighth of a second!).
Bottom line, I should have updated the UDF to this method years ago!
Glenn
_________________________
Actually I
am a Rocket Scientist!
