mysql - Selecting specyfic rows CSV data -

mysql - Selecting specyfic rows CSV data -

i working on big csv energy dataflows , stuck 1 problem:

lets file construction follows:

line1|data line2|data line3|data line4|data line5|data line1|data line2|data line1|data line2|data line3|data line4|data line5|data

could guide me best approach in order select info beetwen line1-line5 1 beetwen line1-line3 shouldn't used? => extract info meet criteria.

what should use: excel, sql, javascript... how should approach this?

thanks!

i grep grep out wanted or didn't want.

http://unixhelp.ed.ac.uk/cgi/man-cgi?grep

mysql excel csv data-analysis