Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Neil Shephard <nshephard@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | Re: st: CSV read with limits |
| Date | Fri, 11 Mar 2011 16:54:00 +0000 |
On Fri, Mar 11, 2011 at 4:46 PM, Dimitriy V. Masterov <dvmaster@gmail.com> wrote: > > Also, csv files have a limit of 70K rows, so watch out. Really? Are you sure this is not an issue when using CSV files with M$-Excel? CSV files are just plain ASCII and there's no reason why there should be a limit on the number of lines. To check I just tried putting the line number into a test file and counted the number of lines and I could get 80000 lines into a text file no problem (this is a GNU/Linux system using some simple Bash scripting and the 'wc' command to count the number of lines)... $ for x in $(seq 1 80000); do echo '"$x"' >> test.txt; done $ wc -l test.txt 80000 test.txt First line appends the number to the files test.txt 80000 times, the second line then counts the number of lines in test.txt All 80000 numbers were echoed to the file and present and it wasn't truncated at 70000 lines. Neil -- “Truth in science can be defined as the working hypothesis best suited to open the way to the next better one.” - Konrad Lorenz Email - nshephard@gmail.com Website - http://kimura.no-ip.org/ Photos - http://www.flickr.com/photos/slackline/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/