in reply to Remove array if data inconsistent

The only thing I could thing of would be removing rows where there where a specific number of zeros are in the row, but that’s not going to help me in the long run.

So what are the criteria for filtering the lines? Should all be preserved that start with ISNAUTH?

We can help you to implement something when you tell us what you want to do, but we don't know your business and can't help you if you can't even give us a description in natural language.

Replies are listed 'Best First'.
Re^2: Remove array if data inconsistent
by meredib (Acolyte) on Apr 22, 2009 at 14:26 UTC
    Oh geez sorry about that. No the first column does not matter. It's the remaining columns that I care about, I only want to see something that has values greater than zero consistently. For instance let’s say there are 15 rows and the first 5 are zero and within the last 10, 8 have values greater than zero.
      Ok, then the first step is to parse the file. That's been done many times before, and you should re-use such a solution, like Text::CSV or Text::CSV_XS.

      Then you have each row as an array, and you only have to iterate over them and check the condition you described.

      So do it, and when you run into problems come back with more specific questions.