This is an example of the source file:

SUUTIN STAMM 2/60AST;SUUTIN STAMM 2,0/60 AST.           VIIRAOSA (PK-1
+)
SUUTINKÄRKI SPRAY TP 9501 E-SS;SUUTIN  VALME HOL0125624 TP 9501    E-S
+S
O-RENGAS 790X12 FPM;UPPOPUMPPU PUMPEX KV56
O-RENGAS 99X7 FPM;RULLAUSPÄÄ B NORMAALI
KÄSISAHA SANDV 2600-22-XT L=22IN;KÄSISAHA 22 IN 2600-22-XT          SA
+NDVIK
VEITSI STANL 10-010;MATTOVEITSI STANLEY 2-10-099 99E
VEITSENTERÄ STANL 11-916 L=62MM SUORA;MATTOVEITSENTERÄ  STANLEY 0-11-9
+21    (5KPL/PAK)  PITT. 49
KAAVAIN TIZIT 620-20 H10;TASOKAAVAIN SANDVIK 620-25
[download]

This is supposed to be the goal:

SUUTIN STAMM 2/60AST;SUUTIN STAMM 2,0/60 AST.           VIIRAOSA (PK-1
+);3;2
SUUTINKÄRKI SPRAY TP 9501 E-SS;SUUTIN  VALME HOL0125624 TP 9501    E-S
+S;5;2
O-RENGAS 790X12 FPM;UPPOPUMPPU PUMPEX KV56;3;0
O-RENGAS 99X7 FPM;RULLAUSPÄÄ B NORMAALI;3;0
KÄSISAHA SANDV 2600-22-XT L=22IN;KÄSISAHA 22 IN 2600-22-XT          SA
+NDVIK;4;3
VEITSI STANL 10-010;MATTOVEITSI STANLEY 2-10-099 99E;3;2
VEITSENTERÄ STANL 11-916 L=62MM SUORA;MATTOVEITSENTERÄ  STANLEY 0-11-9
+21    (5KPL/PAK)  PITT. 49;5;2
KAAVAIN TIZIT 620-20 H10;TASOKAAVAIN SANDVIK 620-25;4;1
[download]

Structure is: "word1 word2 word3;bla hword1bla word2h blah;3(words in 1st column);2(words found a match from 2nd column)" Ok I made changes in the code which now looks like this:

#!perl

use strict;
use warnings;

my $readfile = 'blah.csv';
my $writefile = 'bleh.csv';

open my $fh, "<", $readfile;

my $row = <$fh>;
my $found = 0;
my @cols;
my (@col1,@col2);
my @words = split(/\s+/,@col1);

open my $wfh, ">", $writefile or die "yikes: $!";

while (<$fh>) {
    tr /a-z/A-Z/;
    chomp;
    my @cols = split /\;/;
    push @col1, $cols[0];
    push @col2, $cols[1];
    my @words = @words + 1;

    if ( @col2 =~ m/$words[$_](\d+)/ ) {
        $found++;
    }

    print $wfh "$row';'@words';'$found";

    $found = 0;
    @words = 0;
}
[download]

Now I get report:

Applying pattern match (m//) to @array will act on scalar(@array) at C
+:\blah\vertailu2.pl line 27.
Argument "LSAIDHA 2FA SFF ;ASD 2FA AASDA" isn't numeric in array eleme
+nt at C:\blah\vertailu2.pl line 27, <$fh>
Argument "3FASFL FAAL;DAOIADJAD" isn't numeric in array element at C:\
+blah\vertailu2.pl line 27, <$fh> line
Argument "ASFD ADD AD7A ALUYAD;ADLIHADBA A DADASFD DADD" isn't numeric
+ in array element at C:\blah\vertailu2.pl line 27, <$fh> line 4.
[download]

I'm guessing I should somehow define the program to handle both numbers and letters. Don't know how to do it though..

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.