Tab-Separated File Search

[nigeledge]

I have a text file like so:

product1      D393494832
product2      M230234938
product3      A784565454

They are tab-separated values.

I need to be able to open the text file, search for a product id (e.g. "product2") and return the value (e.g. "M230234938"). Is this possible?

Any help is greatly appreciated.

[Weedpacket]

Yes, it's possible to read a file as separate lines, find the tab, find the bit before the tab and find the bit after the tab.

Which bit of your code are you needing help with?

[nigeledge]

Thanks, I just needed a little assurance that I wasn't going to waste my time 🙂 I figured it out. There might be an easier way to do it, but this is what I came up with...

$path = ".";
	$productFile = $path."/products.txt";

$searchKey = "product2";

if (file_exists($productFile)) {

	$fp = fopen($productFile, "r");	
	while(!feof($fp)) { 
	     $ftext .= fread($fp, 1024);
	 } 
	$fentry = explode("\r",$ftext);

	for($i=0;$i<sizeOf($fentry);$i++) {
		$flineentry = explode("\t",$fentry[$i]);
		for($j=0;$j<sizeOf($flineentry);$j++) {
			$entryResult = trim($flineentry[$j]);
			if($entryResult==$searchKey) {
				// echo("match<br/>");
				$result = trim($flineentry[$j+1]);
				break;
			}
		}			
	}
	echo("result=".$result);	
} else {
	echo("result=");	
}

[Shrike]

$fContents = file($file);
for($i=0;$i<count($fContents)-1; $i++){
  $fContents[$i] = preg_split("/\t+/", $fContents[$i]);
  if(trim($fContents[$i][1]) == $searchkey){
    $result = $fContents[$i][1];
    break;
  }
}
echo $result;

[daveyboy]

your code searches all the data fields, not just the product id. just check $flineentry[0]