Shell Programming and Scripting

Hi Everyone,
Im currently using the below code to pull data from a large CSV file and put it into smaller files with just the data associated with the number that I "grep".

Code:

grep 'M053' test.csv > test053.csv

Is there a way that I can use grep to run through my file like the example below and take each line that has a match for the first 4 digits and write the matches to a corresponding file? I can use the above command to get this done but I want to know of a way to run a command or script that will process the whole file at one time. So given the below data I would end up with 5 different files IE test051.csv test053.csv, test103.csv, test105.csv and test115.csv also these numbers will change from 051 to 999. Thanks in advance

Code:

M051POD071,
M053POD071,
M103POD075,
M105POD073,
M105POD075,
M115PAD011,
M115PAD012,
M115PAD024,

Try

Code:

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

Ok that totally work can you explain how that worked? I did not have any idea that awk would have done that.

Thank you!!!!

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

Thank you again!

Once last question as I'm sure they will change the data on me again at some point. How would I compensate for a change to the data where they leave off the "M"? like in the below data?

Code:

M051POD071, M053POD071, M103POD075, 105POD073, M105POD075, M115PAD011, 115PAD012, M115PAD024,

Try

Code:

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

Once again thank you! That worked great.