Searching a Tab Deliminated Text File (I dont even know where to start)

d22552000 · October 7, 2007

OK, I am trying to make a program to read a text file with the following format:

FILEID\tFILENAME\r\n
FILEID\tFILENAME\r\n

I know to use split("\t",$string); to split the fileid from the name, but still how would I go abouts reading this file and looking for the line that has the name?

I though of using eregi but then I though "hmm, that would be incredibly server intensive"

so what do you think I can or should do?

ludjer · October 7, 2007

try get all the names and id's into a array

$arr = array( "fileid" => array(),

"fname" => array());

$arr[fileid][0] = "fileid1";

$arr[fname][0] = "filename1";

use a for loop to search it, i think that would be the fastest

d22552000 · October 7, 2007

not exactly sure what you mean...

I have hte file contents stored in STRING

CURRENT SEARCH CODE:

<?PHP
$string = file_get_contents(./Files/file.lst');



?>

FILE.LST:

7504434428	*.exe
7513176882	*.bat
7562112438	*.rar
7575651003	*.zip

I replaced the names with stars, and NO we do not have 75billion uploads, its a rand number.

how would I change that to array?

heckenschutze · October 7, 2007

If you want to search for the id:

<?php
$h = NULL;
$cols = array();
$line = "";

if(($h = @fopen('file.txt', 'rb')) === FALSE)
    die('Failed to open some file');

while(($line = @fgets($h)) !== FALSE)
{
    $cols = explode('\t', $h);
    /* $cols[0] is the fileid */
    /* $cols[1] is the filename */
}


fclose($h);
?>

Search or do whatever.

d22552000 · October 7, 2007

ok dudes, well, I am actually loading this text file cause im gonna allow hte user to do a PARTIAL and WILDCARD search on the FILENAME's. I already have one where they type part of the ID and it goes to it. I am making a fulltext search of the filenames... Would you be able to help me with that? lol. (I shoulda clarified)

The above SRC would work, but how would I search $cols[1] ? there is no find or search command in php...

heckenschutze · October 7, 2007

No, but there are regular expressions, take your pick between POSIX or PCRE regex

d22552000 · October 7, 2007

PCRE reg exp

uh, eregi? but then how would I echo results?

yzerman · October 7, 2007

preg_match ftw.

<?php
$fileid = "/^([0-9]{1,20}).*$/";
$filename = "/([a-z0-9_.]{1,255})$/";
//first find the file id
echo "File id's:";
foreach(file('filename.txt') as $haystack) {
preg_match($fileid, $haystack, $matches);
print_r($matches);
}
echo "<br/>";
echo "File Names: ";

//then find the file name
foreach(file('filename.txt') as $haystack) {
preg_match($filename, $haystack, $matches);
print_r($matches);
}
?>

The array shows you can print the value of matches by using $matches[1]. So to answer your question:

echo $matches[1]; //put this in place of print_r($matches)

d22552000 · October 7, 2007

ok im trying it out performance wise riight now, I just ran athe script with a loop of 8000 to create 8000 diferent file id's and names, im going to search them now with the above script and time it. Thanks there guys for helping me out! woot!

PREG_MATCH FTW!

d22552000 · October 7, 2007

<?php

$fileid = "/^([0-9]{1,20}).*$/";
$filename = "/([a-z0-9_.]{1,255})$/";

echo "File id's:";

foreach(file('./Files/file.lst') as $haystack) {
preg_match($fileid, $haystack, $matches);
print_r($matches);
}
echo "<br/>\r\n<br/>\r\nFile Names: ";

foreach(file('./Files/file.lst') as $haystack) {
preg_match($filename, $haystack, $matches);
print_r($matches);
}

?>

The only problem with this code, is... Where do I feed in the $_GET or $_POST search terms? I understand preg_match but should I then replace the preg term with the search term!? (I noticed it was regular expression but I could do string matching because it is word searching, that would be way faster wouldn't it? *without the preg engine*) I am not sure, but I am overlooking the $NEEDLE...

d22552000 · October 7, 2007

ok, I have made ascript to split the numbers (id) from the names (files)...

CODE:

<?php

$string = file_get_contents('./Files/file.lst');

foreach(file('./Files/file.lst') as $haystack) {
list($ID[], $FI[]) = split("[\t]", $haystack);
}

echo '<PRE>';
print_r($ID);
print_r($FI);
echo '</PRE>';
?>

THIS OUTPUTS:

Array
(
   [0] => 7504434428
   [1] => 7513176882
   [2] => 7562112438
   [3] => 7575651003
   [4] => 7081649567
   [5] => 7190396421
   [6] => 7233149017
   [7] => 7234947174
   [8] => 7240136136
   [9] => 7241585907
   [10] => 7251364519
)
Array
(
   [0] => *.exe

   [1] => *.bat

   [2] => *.bat

   [3] => *.bat

   [4] => 

   [5] => *.gif

   [6] => *.exe

   [7] => *.exe

   [8] => *.exe

   [9] => *.exe

   [10] => *.exe
)

I replaced the filenames with * but you get the point, now could I loop thorugh the array saying foreach ($ID => $FI as $FIID && $FILE) ?? (HELP PLZ)

d22552000 · October 7, 2007

OK so please help me!!! My current source is:

<PRE>
<?php

$string = file_get_contents('./Files/file.lst');
$MATCH = 'a';

foreach(file('./Files/file.lst') as $haystack) {
$ID[] = str_replace("\r\n",'',split("[\t]", $haystack));
}

foreach ($ID as $IDNM => $FIL) {
  foreach ($FIL as $FILE) {
    if (eregi($MATCH, $FILE)) {$R++;
      $RET.="<TR><TD>$FILE</TD><TD>ID: $IDNM</TD></TR>\r\n";

      $IDFND[$FILE] = $IDNM;

      foreach ($FIL as $IDS) {
        if ($d=1) {
          $Z.= $IDS."{}"; $d++;
        } else if ($d=2) {
          $Z.= $IDS."\r\n"; $d=1;
        }
      }
    }
  }
}
echo $Z;
print_r($IDFND);
print_r($ID);

echo $string;

echo "<div align=\"center\">$R Results Returned:\r\n\r\n<br/>";
echo "<br/><TABLE WIDTH=\"50%\">".$RET.'</TABLE></div>';

?>
</PRE>

The current page output is:

d22552000 · October 7, 2007

help please people...?

d22552000 · October 8, 2007

oh cmon, I am on page 3, can anyone help?

Sign In

Searching a Tab Deliminated Text File (I dont even know where to start)

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information