Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re^5: A complicated file parsing and 2D array/matrix problem.

by Kenosis (Priest)
on Aug 27, 2012 at 18:18 UTC ( #990035=note: print w/replies, xml ) Need Help??

in reply to Re^4: A complicated file parsing and 2D array/matrix problem.
in thread A file parsing and 2D array/matrix problem.

Hi, zing!

What have you tried so far to solve this puzzle?

  • Comment on Re^5: A complicated file parsing and 2D array/matrix problem.

Replies are listed 'Best First'.
Re^6: A complicated file parsing and 2D array/matrix problem.
by zing (Beadle) on Aug 27, 2012 at 19:20 UTC
    Kenosis, This is what Im trying, but is throwing a lot of errors.
    open FILE, "Matrix.txt" or die $!; my @lines = <FILE>; my $size = scalar @lines; my @matrix = (1 .. 3); my $i = 0; my $j = 0; my @micro; foreach ($matrix) { foreach ($lines) { push @{ $micro[$matrix]}, $lines; } }

    CONTENTS OF matrix.txt

    1 2 3 4

    1 5 6 8

    1 7 8 0

    I need to be able to access each element of the matrix thus created on a "one by one basis".

      It may be best to work on the A.txt and B.txt data sets you showed. If you can create a script to generate the ORed results of those two matrices, then it's most likely that script will work with larger matrices.

      First, always begin your scripts with either:

      use strict; use warnings;


      use Modern::Perl;

      I prefer the latter, since it includes the former two pragmas--among other things.

      You can use File::Slurp qw/read_file/; to read a file's contents into an array. The foreach() takes a list or array--not a scalar, like you've done. That would account for some of the errors.

      Here's one way to approach the problem:

      1. Read both matrix files into arrays.
      2. The first element (row 0) of each array is identical, as it contains the column titles. Grab those and create the title string (like in the first script, but w/o sorting), and move to the next rows (1 .. n) of the two arrays.
      3. Split each row (1 .. n) of the two arrays into their elements, placing those elements into two element arrays. The zeroth element of these arrays contains the row label.
      4. Do an OR comparison between the two element arrays (1 .. n), and build an OR-result array for the table.
      5. Finally, build the table and print it.

      The scripting that produced the first table should help with reading files and building the table.

      Step through this scripting process, and then share what you've completed. A script can be created to produce the ORed output you need; it'll just take a little more work...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://990035]
[ovedpo15]: another question about regex. if I have a string like this: "a/b/,c/d/e,5" I would like to remove the string after the last comma so the output will be "a/b/,c/d/e" how to do so?
[Corion]: ovedpo15: You could split on comma, and then join everything together, except the last part. Or you could match and make sure that the last part has no comma, like qr!,[^,]+$!, or you could use rindex.
[ovedpo15]: But I don't know the length of the string. will it still work?
[ovedpo15]: The only thing I know is that there is a comma at the end and a value after that
[hippo]: Try it and see. Your computer won't explode.
[Corion]: length will tell you the length of a string.
[Corion]: But if you are parsing CSV, again, let me point to Text::CSV_XS, which you should use instead

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (9)
As of 2018-05-27 10:36 GMT
Find Nodes?
    Voting Booth?