<div dir="ltr">awk -F, '$5 != "F" { print $0 }' > male.csv < input.csv<div>awk -F, '$5 != "M" { print $0 }' > female.csv < input.csv<br><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 6, 2015 at 7:57 PM, Keith Larson <span dir="ltr"><<a href="mailto:klarson@k12group.net" target="_blank">klarson@k12group.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="font:10pt/normal Segoe UI;font-size-adjust:none;font-stretch:normal"><div><div>I think that awk is the right tool, but I'm open to a better solution if there is one.</div><div><br></div><div>I have a .csv format file that I want to split into two files based on the value found in one of the columns. For discussion purposes, say that the file has several different values about a person. FirstName, LastName, Phone, DOB and Gender. The file does have a header row. I would like two files, one with all entries where gender is M and another file where gender is F. I would like the header row in both files if possible. The key is that I want the row to be kept completely intact with the delimiters remaining in place.</div><div><br></div><div>Any suggested solutions? Ideally, I want something that can be done in a bash script so that I can run this on a nightly schedule.</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Keith Larson<br></div></font></span></div></div>
<br>_______________________________________________<br>
colug-432 mailing list<br>
<a href="mailto:colug-432@colug.net">colug-432@colug.net</a><br>
<a href="http://lists.colug.net/mailman/listinfo/colug-432" rel="noreferrer" target="_blank">http://lists.colug.net/mailman/listinfo/colug-432</a><br>
<br></blockquote></div><br></div>