Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
How can i search for multiple items? I have two part numbers that yield results when searched for separately but when I use a semicolon or "or" nothing comes up. I've multiple variations with spaces and without? What am I missing or is this not possible?
What I am really after is adding a bunch of items to my workspace at the same time from a list I have. If there is a better way to do that I am open to suggestions.
Hi @ZC_10909252
If your system use a solr index search then you can use the semicolon only in the specific attribute filed, not in the key word column.
@Fadel has showed nice example how it works.
PetrH
I do this all the time in Excel. Say I have a list of numbers to search on using that semicolon trick. In the next column over, use "=CONCAT(B2,";",A3)". Fill that formula down and copy the last entry which will be a merging of all the numbers. You can vary by including a * for a wildcard. I've seen this work with 50 parts but there is some limit to how long this can be.
Hi @ZC_10909252,
It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution.
Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.
Regards,
Anurag