Hi Everyone!
I have possibly a unique problem for you, I am using Sublime Text 3 to read in my data from an experiment. My experiment yields in excess of 5 million data points giving each one on a separate line, I do my data analysis in a program called OriginLab which is plotting software with integrated spreadsheet software, because my data set is so large I max out the number of rows in the spreadsheet software so need to do this in chunks - I tend to split the data in half and this usually does the trick.
The problem is presently I highlight and shift + page down to select the chunk of data I wish to split; this still takes a very long time and there must be a better way to do this. Is there a way; either natively or with a package, to highlight/select and range based on line. E.g highlight/select lines 1 to 2,500,000 without manually doing this
Any ideas or tips would be greatly appreciated and this would save me so much time!
Thank you very much,
QP