Parse problems

[ashleyxxx]

Hi I have been running into a problem that seem to be giving me a hard time.
I am parsing a document that is filled with numbers that looks like this.
KML001-002-003-004-XML001⁰⁰⁵
I need the output to look like this;
KML001
KML002
KML003
XML001
XML002
Then I ned to fill in the missing numbers between the ^ sign.
Any thoughts how this could be done would be great.
Thanks in advance.

[ashleyxxx]

😕 Is it even possible to feel in the missing numbers ?

[ashleyxxx]

Nobody knows

[sneakyimp]

Your description of what you need to do is pretty vague. For instance, it's not clear if you are specifying a single line in your file or whether the file is all one line with no line breaks.

From what I can tell it looks like you want to look for a series of 3 letters and then locate all the dash-separated numbers that follow up to the next 3-letter sequence, correct?

What I don't understand is where the XML002 comes from. I see no 002 following the XML.

You're going to have to be more clear about what you want.

[ashleyxxx]

sneakyimp;10971877 wrote:

Your description of what you need to do is pretty vague. For instance, it's not clear if you are specifying a single line in your file or whether the file is all one line with no line breaks.

From what I can tell it looks like you want to look for a series of 3 letters and then locate all the dash-separated numbers that follow up to the next 3-letter sequence, correct?

What I don't understand is where the XML002 comes from. I see no 002 following the XML.

You're going to have to be more clear about what you want.

That is correct three letters and three numbers then follow by a dash with three numbers. The numbers are multi-line sometime. As far as the XML002 I need to feel in all the missing numbers between XML001 and 005. When this (⁾ appears
I need to feel in the missing number or numbers.

Thank you

[sneakyimp]

<?php

$str = 'KML001-002-003-004-XML001^005';
$pattern = '/[a-z]{3}[0-9\-\^]+/i';

$matches = preg_match_all($pattern, $str, $major_series);

if (!$matches) die('no matches were found');
else echo $matches . ' major series were found <br>';


foreach($major_series[0] as $maj) {
  $letters = substr($maj, 0, 3);
  $numbers = substr($maj, 3);
  if (strstr($numbers, '^')) {
    $number_pieces = explode('^', $numbers);
    $lo_number = intval($number_pieces[0]);
    $hi_number = intval($number_pieces[1]);
    for($i=$lo_number; $i<=$hi_number; $i++) {
      echo $letters . str_pad(strval($i), 3, '0', STR_PAD_LEFT) . '<br>';
    }
  } else {
    $matches = preg_match_all('/\d+/', $numbers, $num_matches);
    if ($matches) {
      foreach($num_matches[0] as $num) {
        echo $letters . $num . '<br>';
      }
    } else {
      echo 'No number matches found<br>';
    }
  }
}



?>

[ashleyxxx]

sneakyimp;10971895 wrote:

<?php

$str = 'KML001-002-003-004-XML001^005';
$pattern = '/[a-z]{3}[0-9\-\^]+/i';

$matches = preg_match_all($pattern, $str, $major_series);

if (!$matches) die('no matches were found');
else echo $matches . ' major series were found <br>';


foreach($major_series[0] as $maj) {
  $letters = substr($maj, 0, 3);
  $numbers = substr($maj, 3);
  if (strstr($numbers, '^')) {
    $number_pieces = explode('^', $numbers);
    $lo_number = intval($number_pieces[0]);
    $hi_number = intval($number_pieces[1]);
    for($i=$lo_number; $i<=$hi_number; $i++) {
      echo $letters . str_pad(strval($i), 3, '0', STR_PAD_LEFT) . '<br>';
    }
  } else {
    $matches = preg_match_all('/\d+/', $numbers, $num_matches);
    if ($matches) {
      foreach($num_matches[0] as $num) {
        echo $letters . $num . '<br>';
      }
    } else {
      echo 'No number matches found<br>';
    }
  }
}



?>

Thank you I will give it a try

[ashleyxxx]

sneakyimp;10971895 wrote:

<?php

$str = 'KML001-002-003-004-XML001^005';
$pattern = '/[a-z]{3}[0-9\-\^]+/i';

$matches = preg_match_all($pattern, $str, $major_series);

if (!$matches) die('no matches were found');
else echo $matches . ' major series were found <br>';


foreach($major_series[0] as $maj) {
  $letters = substr($maj, 0, 3);
  $numbers = substr($maj, 3);
  if (strstr($numbers, '^')) {
    $number_pieces = explode('^', $numbers);
    $lo_number = intval($number_pieces[0]);
    $hi_number = intval($number_pieces[1]);
    for($i=$lo_number; $i<=$hi_number; $i++) {
      echo $letters . str_pad(strval($i), 3, '0', STR_PAD_LEFT) . '<br>';
    }
  } else {
    $matches = preg_match_all('/\d+/', $numbers, $num_matches);
    if ($matches) {
      foreach($num_matches[0] as $num) {
        echo $letters . $num . '<br>';
      }
    } else {
      echo 'No number matches found<br>';
    }
  }
}



?>

If you dont mind me asking how long have you been writing in php ?

[sneakyimp]

About 7 years.

[ashleyxxx]

sneakyimp;10971917 wrote:

About 7 years.

Thats really cool, I have only been writing code for almost 2 years now I am still learning, by the way the code seems to be working great. Thank you so much. And did you write the salary calculator.

[sneakyimp]

Glad the code is working. It's functionality is quite narrow so I wasn't sure it would work.

The salary calculator was a collaboration. I had the pleasure of working with a very very smart guy who had located all of the data and created the design. I just hooked in the PHP and Javascript.

[ashleyxxx]

sneakyimp;10971931 wrote:

Glad the code is working. It's functionality is quite narrow so I wasn't sure it would work.

The salary calculator was a collaboration. I had the pleasure of working with a very very smart guy who had located all of the data and created the design. I just hooked in the PHP and Javascript.

Thats really cool. The salary calculator looks really intricate and complex. Hopefully I will become a great programmer in the future I have been going over php.net and learning new functions but not always sure how to implement them in some of my projects. If you wouldnt mind I may ask for your help with some javascript in the near future.

[sneakyimp]

The calculator is not particularly complex. There are some database tables that associate some specific careers with career categories and which associate metropolitan locations with states. The PHP renders that data into some Javascript arrays. When you change one of the selector inputs, it populates another selector from the appropriate array. Ultimately, we run a query based on the form inputs.

[ashleyxxx]

sneakyimp;10971935 wrote:

The calculator is not particularly complex. There are some database tables that associate some specific careers with career categories and which associate metropolitan locations with states. The PHP renders that data into some Javascript arrays. When you change one of the selector inputs, it populates another selector from the appropriate array. Ultimately, we run a query based on the form inputs.

Sorry it took me so long to get back to you. I have been trying to catch up with all my work it just has been really chaotic lately. Are you using mysql for the database ?

[sneakyimp]

ashleyxxx;10972133 wrote:

Sorry it took me so long to get back to you. I have been trying to catch up with all my work it just has been really chaotic lately. Are you using mysql for the database ?

Yes.

[ashleyxxx]

sneakyimp;10972144 wrote:

Yes.

Then you are using the innodb engine for table relations do you notice any performance issues. If I am correct.

[sneakyimp]

I think we use more than one table type and the majority are MyISAM. I don't remember exactly. I haven't noticed any performance problems myself. If you run across any, let me know 😉

[ashleyxxx]

sneakyimp;10972156 wrote:

I think we use more than one table type and the majority are MyISAM. I don't remember exactly. I haven't noticed any performance problems myself. If you run across any, let me know 😉

Would you know by any chance if it is possible to parse through a hard drive to find certain values and create a log. I have no clue how to do this and my boss wants me to get it done right away.

[sneakyimp]

when you 'parse through a hard drive' you are going to be looking into the contents of various files.

If it's a linux system, then you can use the grep command:
http://unixhelp.ed.ac.uk/CGI/man-cgi?grep

It supports all kinds of search options. I recommend you start a new thread.

[ashleyxxx]

sneakyimp;10972260 wrote:

when you 'parse through a hard drive' you are going to be looking into the contents of various files.

If it's a linux system, then you can use the grep command:
http://unixhelp.ed.ac.uk/CGI/man-cgi?grep

It supports all kinds of search options. I recommend you start a new thread.

Ok I will start a new thread but will please be a part of it 😉 As far as if it is a linux
system that I do not know. I think more universal to search through windows, mac ,
and all web browsers for certain key words. If there is a match insert it into the database and also create a log and email it to the admin of the network.
What do you think I should call the thread?