Had a script done by RSampson last week that stripped a file and created a new file whenever it found |2102| in the Years column. Problem is it runs on all files in a directory but the Years column is not always in the same column. Additionally a data value could be 2012 also as I found out. Thus I need some tweaks. You will see below that the 2nd row of data contains |2012| however that's Units and not Years. Thus current script grabbed that row which is a problem I didn't forsee. So is there a way I can define which column to search for 2012 for each file? So somewhere in the script I can list out the filenames and which column to look for 2012 in?
Style 01 7 75 756 03 01 899833|Fiscal Rcpt Feb|MdseTyp F|2012|1938|6143.46|445.74
Style 01 7 75 756 03 01 899833|Fiscal Rcpt Jan|MdseTyp F|2011|2012