How to use PHP preg_replace on a formatted number based on search query while ignoring comma and decimal?

I want to highlight my search query on a formatted number.

For example:

$search_query = '1234'; // or $search_query = '7800';
$formatted_numeber = '12,345,678.00';

Currently my code is:

preg_replace('/(' . $search_query . ')/i', "<span style='background: yellow'>$1</span>", $formatted_numeber);

But this code fails to highlight search clause like '1234' , '7800' due to presence of commas (,) and decimal (.)

Also i want this to work with the presence of commas and decimals in the search query.

For example:

$search_query = '3,456';
$formatted_numeber = '12,345,678.00';

I want to highlight the part "345,6" on my formatted number.

Or:

$search_query = '7.80';
$formatted_numeber = '12,345,678.00';

I want to highlight the part "78.0" on my formatted number.

FCNahian

1 year ago

Best Answer

Level 2

Got the solution on stackoverflow and tweaked it a bit for a bug.

Reference: https://stackoverflow.com/questions/78959860/how-to-use-php-preg-replace-on-a-formatted-number-based-on-search-query-while-ig


private function highlightSearchClause(string $search, string $number)
    {
        if ($search != '' && $search != null && $search != []) {
            $searchBegin = NULL;
            $searchIndex = 0;
            $search      = str_replace([',', '.'], '', $search);
            foreach (str_split($number) as $numberIndex => $character) {
                if ($character == $search[$searchIndex]) {
                    if (is_null($searchBegin)) {
                        $searchBegin = $numberIndex;
                    }
                    $searchIndex++;
                    if ($searchIndex == strlen($search)) {
                        return substr($number, 0, $searchBegin) .
                            '<span style="background: yellow">' .
                            substr($number, $searchBegin, $numberIndex - $searchBegin + 1) .
                            '</span>' .
                            substr($number, $numberIndex + 1);
                    }
                } elseif (!in_array($character, [',', '.'])) {
                    $searchBegin = NULL;
                    $searchIndex = 0;
                }
            }
        }

        return $number;
    }

1 like

Please or to participate in this conversation.