Text manipulation help

[nogs]

From a report we use I am trying to select lines join the two lines together - I then need to select chunks from the joined up line to upload to mysql , this is as far as I have got can anyone help??

$se1 = if '^Product Code :';
$se2 = if '^PALLETS ';
while (<FILE>)
{
print /$se1/;
print /$se2/;
} Nogs

 

[tanderso]

You'll need to explain your problem a little better.
Sincerely,

Tom Anderson
CEO, Order amid Chaos, Inc.

http://www.oac-design.com

 

[nogs]

Tanderso
from a report I want to extract lines beginning with two different criteria where these are found I want to then join them and carry on looking for more occurances to add together.
Once I have all of the lines joined I want to select from the lines (using substr - I think) and upload the data to mysql. Nogs

 

[tanderso]

It's still not very clear. But it sounds like a data structure other than a string would be useful.

my $se1 = "Product Code         :";    
my $se2 = "PALLETS   ";

my @se1; my @se2;

while (<FILE>)
{
  push @se1, $_ if /^$se1/;
  push @se2, $_ if /^$se2/;
}

for (my $x = 0; $x < scalar @se1; $x++) {...insert in database...}
for (my $x = 0; $x < scalar @se2; $x++) {...insert in database...}

Sincerely,

Tom Anderson
CEO, Order amid Chaos, Inc.

http://www.oac-design.com

 

[nogs]

tanderso
the file I want to extract the data from has in it summaries of product codes which can be 6 lines long for each product, the data I require is within 2 lines one begins with Product Code and one with PALLETS. I think it would be easier at this point to join together the two lines for each product? I then want to select from the products line key chunks of data using substr and upload the data to mysql - sorry I hope that is a little clearer. Nogs

 

[tanderso]

Concatenating and splitting strings is not the best way to store data. Use a hash or an array or an array of hashes, etc. Please construct a more concise question to get a more detailed answer. I'm willing to help if you're stuck on some specific problem, but if you're looking for someone to write you a whole program, I'd need a contract and a deposit.
Sincerely,

Tom Anderson
CEO, Order amid Chaos, Inc.

http://www.oac-design.com