In my work I will use Golden Eagle Sorter if you do not have a license you can use the free version.
Prepare through the U:L:P bases.
Further, in order to remove garbage from the base and bring it to the same format it is necessary to normalize it. The function will erase all empty strings and add https:// to the beginning of the string. It will remove long strings or where there is no data. Select a function. In the window select the text file with the base and then enter a name to save the normalized base. Below are screenshots of how to use it.
Next, let’s start searching for the necessary lines. There is a file with requests in the program folder.
1- to search for WordPress sites
2 – to search for cPanel admin panels
3 – Other sites
Here enter any search terms depending on your needs. Note: if you sort by port, you don’t need to specify the : sign. Example on the screenshot.
IMPORTANT
Put the ULP bases in the PACKAGE and specify it in the program.
The screens below show an example of how to use it.
Done. You have sorted strings from the database.