Do a search for on page with text

Hello everyone

I have a database called garage.
In it I have 2 columns, the first is named car, the second license plate.

For example :

Car = Audi Blue
License plate = ZE-34-HE

I have a page containing information obtained by APIs that cannot be modified, including the License plate (ZE-34-HE)

I’d like to be able to display the car (Audi Blue) contained in the database on this same page from the License Plate.

I can find all the cars with a “Do a search for” but not the Audi that matches the plate.

Could you please help me?

You will simply add a constraint to your Do a search for to find the cars with the plates not in the list of that API call. See an example below:

You can try using find and replace twice, once for ( and another for ) to remove those from value provided by API or use regex to do it.

Thank you for your reply @boston85719 , I’ve tried and it doesn’t work. :frowning:

I thought you are trying to exclude the audi. Then you should do the same and use is in after the plate, instead of isn't in in this picture.

@hergin Thanks for your help. I tried but it doesn’t work. I haven’t been able to put your good advice into practice.