Formatting data based on the search field

[hebertlima]

In a scenario where masking and formatting of values are not saved in the database, is there a way to sanitize these fields before conducting a search?

For example:
In the database, the "doc" field is stored as: 4444444444, while the input for searching is 44.444.444-44.

When I perform the search like this: 44.444.444-44, it doesn't yield any results.

It only works if I search exactly like this: 4444444444.

Something like:

public function transformData()
{
    return [
        'doc' => preg_replace('/\D/', '', $this->query('doc')),
    ];
}

I am using the same field to search for names, emails, etc.

[driesvints]

Hi there,

Thanks for reporting but it looks like this is a question which can be asked on a support channel. Please only use this issue tracker for reporting bugs with the library itself. If you have a question on how to use functionality provided by this repo you can try one of the following channels:

• Laracasts Forums
• Laravel.io Forums
• StackOverflow
• Discord
• Larachat
• IRC

However, this issue will not be locked and everyone is still free to discuss solutions to your problem!

Thanks.