<div dir="ltr"><div>I have a csv file that looks something like this:</div><div> </div><div>12/5/2013,14:12,,1,2,3,14160.00,,,,profdm1,,,property, etc</div><div>12/5/2013,14:12,,1,2,3,14160.00,,,,,,,,property, etc</div><div>
</div><div>There are and can be several lines in this file.</div><div> </div><div>What I want to do is split this file into multiple files based on ONE factor alone.</div><div>Field 12 (where is has profdm1 in line 1) </div>
<div>If that field has a value, I want that line and all subsequent lines below it where field 12 is null to be split into a file, then when it encounters field 12 has a value in it, create a new file and repeat this process thru the end of the file....</div>
<div> </div><div>So the original file may have, for example, 5 lines where field 12 has a value....so this process should split the csv file into 5 files.....each having the line where field 12 has a value and ALL other lines below it, UNTIL it finds the next line where field 12 has a value....</div>
<div> </div><div>I have looked at awk/gawk and don't see anywhere that you can set parameters to do this...</div><div>Perhaps Perl?</div><div> </div><div>Hoping someone has had to do something like this before and knows a good solution...</div>
<div> </div><div>thanks</div><div> </div><div>Scott</div><div>PDM</div><div> </div><div> </div></div>