Need help with searching for patterns in username field values...
I want to know if anyone has suggestions for the best way to search for a pattern in a username field. Do I use subsearches or a join or anything else? The username field is a concatenation of the first_name and last_name fields and then 4 digits are added to the end.
Examples:
first_name last_name username
rina Goletz rigol9911
dannie Parden dannparde1234
I was thinking of extracting first two digits of first_name and first_name fields then searching for:
| search username="first_name_first_two\.*last_name_first_two.\*\d\d\d\d"
What would be the best way to accomplish that search?
... View more