Does this need regex to remove data from a list?

simlon

Hi,

I have this text file with a list of data like this:

"rollerblade",26,
"skates rollerblade",15,
"rollerblade inline",12,
"rollerblade inline skates",11,

But I just want the first phrase without the quotes
like this:

rollerblade
skates rollerblade
rollerblade inline
rollerblade inline skates

What is the simplest way to do this in php ?
Is regex what I need ?

I guess I need to find the ", and delete from after that ?

How would I do that ?

Thanks.
David.

simlon

So ...

I will start by putting them into an array ...

$all_prodkeys = file_get_contents($prodkeys);
$prodkeys_arr = explode("\n", $all_prodkeys);

foreach ($prodkeys_arr as $key => $value) {
$prodkeys_arr [$key] = ???? ($value);
}

SO .. its that bit with the ??? that I think needs a regex ?

maxxd

Have you tried something along the lines of this?

$all_prodkeys = '"rollerblade",26,
"skates rollerblade",15,
"rollerblade inline",12,
"rollerblade inline skates",11,';

$prodkeys_arr = explode(PHP_EOL, $all_prodkeys);
$prods = [];
foreach($prodkeys_arr as $id=>$string){
	$prod = explode(',', str_replace('"','',$string));
	$prods[] = $prod[0];
}
$prods = array_filter($prods);
print("<pre>".var_export($prods, true)."</pre>");

In my testing, this outputs the following:

array (
  0 => 'rollerblade',
  1 => 'skates rollerblade',
  2 => 'rollerblade inline',
  3 => 'rollerblade inline skates',
)

simlon

Thanks for helping

I think this should do it without using regex.

$thekeys = array();
$outfile = 'prod_keys';
$all_prodkeys = file_get_contents($prodkeys);
$prodkeys_arr = explode(PHP_EOL, $all_prodkeys); 
foreach (prodkeys_arr as $value) {
   $new_value = str_replace('"','',$value);
   $pos = strpos($new_value, ',');
   $new_value = substr($new_value,0,($pos-1)); 
   $thekeys[] = $new_value;
}

$thekeys = implode(PHP_EOL,$thekeys);
file_put_contents($outfile, $thekeys);

Unless I have made a mistake !

Weedpacket

A regular expression might be simpler...

preg_match_all('/^"(.*)"/m', file_get_contents($filename), $products);
$products= $products[1];

But if that really is what it appears to be - a CSV file, then [man]fgetcsv[/man] would be a more robust approach.

simlon

Looks Good,
Thanks 🙂