I have generated a tab delimited text file using MS Excel. This text file, when opened in Notepad, seems to be correct, with all 6800 rows and 47 columns. I then read this file with PHP and count the elements in the array:
$import = file(../import.txt");
$number_entries=count($import);
echo $number_entries;
Everything seems to work except that there are only about 3800 elements... What has happened to the rest of my rows? I assume that it has something to do with the /n's and /r's in my original file, but I can't seem to reslove it...
Any help would be wonderful.
Thanks, Ben.