I generally use the following format to limit specific search results from panel to panel. However, in this case I would like to search for anything containing the string.
[|loadjob $work_center_base$ | stats values(work_center) as location]
This would limit the results in my search to only what is in the work_center field. I would like to match anything that contains what is in the location field. I won't this as the locations have more description after the work_center.
1CAP1 1CAP2 1CAP3 1CAP4
location (examples to match)
I am wondering if I can alter my search to match these and keep all locations that contain partials of work_center.