Do you ever want to take some lines from the middle of a file say, lines 300-400? You can do that in a kludgey way with Unix head and tail:
cat ids.csv | head -400 | tail -100
The take command from vbin tools does just that.
cat ids.csv |take 300 400
Here we flatten the results and build an SQL IN statement:
cat ids.csv |take 20001 30000 |tr '\n' ' ' | sed "s/ /, /g" > get_customers.sql
By adding a little SQL before and after the list we get something like this:
select distinct u.customer_id, u.state from imports i join usage u on i.id = u.import_id where i.id in ( 40722, 41483, 50364, 52623, 53049, 54795, 73451, ... (thousands of ids here) ... 986764, 986764, 986764, 986764, 986764, 986764 );
So, go ahead, takes some lines.
Also see clip, for panning right to left.