Jump to content

Remove all instances of a string but keep only one in php also sum amounts


Recommended Posts

Hi this is my first post after registering here. Please help me.

I have a string of user data comma separated as below and pipe separated.I have been trying to remove duplicates by converting it to array. And even with php But it all does not works. My data looks like below:


I have tried What's the best way to remove duplicates from a string in PHP (or any language)?detecting duplicate string in a explode function php and like this How to detect duplicate values in PHP array? one too. But none of these works in my case. Coz my data is not unique for same User say Marja_Roxburgh. I wants to remove all entries of Marja_Roxburgh based on its email but also wants to keep the first one only and sum all amounts from its transactions. I've been googling for any logic Im not able to understand what to do this it. How Do I keep only first Record of Marja_Roxburgh and remove all other of her. And also sum all her Amounts before removing her data?

I'm missing the logic to understand and solve this problem. Can somebody help me understand this logic? any Ideas?


Link to comment
Share on other sites


$data = "Marja_Roxburgh|abc@abc.com|123-456-7890|N/A|2011-11-17|N/A|N/A|N/A|N/A|N/A|120,

$array = array_map('trim', explode(',', $data));
$results = array();

foreach ($array as $record) {
    $recArray = explode('|', $record);
    $key = $recArray[0];
    $qty = $recArray[10];
    if (isset($results[$key]))
        $results[$key] += $qty;
        $results[$key] = $qty;

echo '<pre>',print_r($results, true),'</pre>';

/**** RESULTS ********************

    [Marja_Roxburgh] => 540
    [Santa_Roxburgh] => 10
    [Saga_Shera] => 0
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.