Search Results

Try awk '{X=substr($1,1,4); gsub (/[A-Za-z]/,"",X); print > ("test" X ".csv")}' file

It creates the requested output file name for the redirection from two constants and the 3 chars (2,3,4) from your data line.

Try awk '{print >("test" substr($1,2,3) ".csv")}' file

OK, to cut a seemingly open ended story short, try awk -F, '{split ($6, T, " "); if (T[1] > 20 && T[2] == "d") print $0}' file
M155POD072,iOS 8.2,iPod touch 5th gen,6.3,CCQM129ZF4K1,31 d 3...

$4 is the forth field. The field separator is specified by -F'[, ]' . So it's either a comma or a space. Now look at your sample data ;)