Brilliant! It works perfectly. Thanks so much for this information. Jeffrey Smith Registrar for Collections Information [log in to unmask] O: 202.633.0348 C: 202-340-4896 [signature_691063453]<https://asia.si.edu/> From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Brad Hubley Sent: Monday, April 24, 2023 11:10 AM To: ListServ tmsusers <[log in to unmask]> Subject: Re: Search for string of object numbers External Email - Exercise Caution This works for me. Create your sequence of Object Numbers in Excel in one column, e.g., [cid:image002.png@01D976A6.470EA0D0] Search for a website that converts a column of numbers to a comma-separated string, e.g., https://capitalizemytitle.com/tools/column-to-comma-separated-list/ and paste your Excel column of Object Numbers into it. In TMS, use Query Assistant to search on Object Number and paste your comma-separated string of Object Numbers (from the website) into it and you should get the results you're after. Brad [Image removed by sender.] Brad Hubley Technician, Entomology & TMS 100 Queen's Park Toronto, ON M5S 2C6 416 586 5764 ROM acknowledges that this museum sits on the ancestral lands of the Wendat, the Haudenosaunee Confederacy, and the Anishinaabek Nation, which includes the Mississaugas of the Credit First Nation, since time immemorial to today. Le ROM reconnaît que le Musée est situé sur les terres ancestrales des Wendats, de la Confédération des Haudenosaunee et de la Nation Anishinabek, y compris la Première Nation des Mississaugas de Credit, et qu'ils occupent ces terres depuis la nuit des temps. From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Sara Smith Sent: Monday, April 24, 2023 11:00 AM To: [log in to unmask] Subject: Re: Search for string of object numbers [EXTERNAL EMAIL] DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. External Email - Exercise Caution Dear Iris, Thank you for your suggestion. Yes, I attempted this with no result sadly. The package is an option but I have several moderately sized groups to update. Alas. Sara Sara C. Smith Director of Collections The Leiden Collection t: +1.646.532.2847 m: +1.917.593.2019 w: www.theleidencollection.com<http://www.theleidencollection.com/> e: [log in to unmask]<mailto:[log in to unmask]> From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Blochel-Dittrich, Iris Sent: Saturday, April 22, 2023 14:38 To: [log in to unmask]<mailto:[log in to unmask]> Subject: AW: Search for string of object numbers External Email - Exercise Caution Hi, did you try 2009.1.1.1*-*2009.1.1.56 ? Or look for "2009.1.1." and drag&drop the needed ones into a package... not the best way, but it might work Arrows is a known bug it is said to be fixed in 9.93 Best, Iris Iris Blochel-Dittrich museum documentation Stiftung Jüdisches Museum Berlin Lindenstrasse 9-14 10969 - Berlin Tel. : +49 30 25993-442 Fax. : +49 30 25933-409 **** CURRENT EXHIBITIONS **** Paris Magnétique. 1905-1940 until 1 May 2023 www.jmberlin.de/en/paris<http://www.jmberlin.de/en/paris> Jewish Life in Germany: Past and Present The core exhibition www.jmberlin.de/en/core-exhibition<http://www.jmberlin.de/en/core-exhibition> **** FOR CHILDREN **** ANOHA - The Children's World of the Jewish Museum Berlin www.anoha.de/en<http://www.anoha.de/en> Von: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> Im Auftrag von Sara Smith Gesendet: Freitag, 21. April 2023 21:00 An: [log in to unmask]<mailto:[log in to unmask]> Betreff: Search for string of object numbers External Email - Exercise Caution Hello! I'm having great difficulty trying to search for a string of records using object numbers: 2009.1.1.1 - 2009.1.1.56 Just need those, I cannot figure out how to get it to work with the advanced query or in the quick find, ultimately for a batch update. 2009.1.1.1*2009.1.1.56 "2009.1.1.1"*"2009.1.1.56" Also my arrow keys don't work in the quick find field. Anyone else experiencing that? Please help. Sara Sara C. Smith Director of Collections The Leiden Collection t: +1.646.532.2847 m: +1.917.593.2019 w: www.theleidencollection.com<http://www.theleidencollection.com/> e: [log in to unmask]<mailto:[log in to unmask]> [Leiden_LOGO_CMYK_dark-preferred] ________________________________ Unless expressly stated otherwise, this message is confidential and may be privileged or otherwise protected from disclosure. It is intended for the addressee(s) only. Access to this e-mail by any other person is unauthorized. If you are not an addressee, any disclosure, dissemination, distribution or copying of the contents of this e-mail or the information herein or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee or have received this e-mail in error, please immediately inform the sender, delete this message from all mailboxes, empty this e-mail from your trash, and destroy all copies. This communication is for informational purposes only. It is not intended as an offer or commitment for any transaction, except as otherwise expressly stated herein. All business terms and conditions, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of The Electrum Group, LLC, its affiliates, principals or related persons. Tigris Group Inc. ("Tigris") is a family office and is not a registered investment adviser. Tigris does not provide investment advisory services to the public. Any investment advisory services will be provided by The Electrum Group LLC, a registered investment adviser. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. ________________________________ Unless expressly stated otherwise, this message is confidential and may be privileged or otherwise protected from disclosure. It is intended for the addressee(s) only. Access to this e-mail by any other person is unauthorized. If you are not an addressee, any disclosure, dissemination, distribution or copying of the contents of this e-mail or the information herein or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee or have received this e-mail in error, please immediately inform the sender, delete this message from all mailboxes, empty this e-mail from your trash, and destroy all copies. This communication is for informational purposes only. It is not intended as an offer or commitment for any transaction, except as otherwise expressly stated herein. All business terms and conditions, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of The Electrum Group, LLC, its affiliates, principals or related persons. Tigris Group Inc. ("Tigris") is a family office and is not a registered investment adviser. Tigris does not provide investment advisory services to the public. Any investment advisory services will be provided by The Electrum Group LLC, a registered investment adviser. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. On now at ROM, T. rex: The Ultimate Predator<https://www.rom.on.ca/en/exhibitions-galleries/exhibitions/t-rex-the-ultimate-predator> explores the mighty T. rex - from Baby to Beast. Book tickets at rom.ca<https://www.rom.on.ca/en>. ________________________________ À l'affiche du ROM, T. Rex : Le prédateur suprême<https://www.rom.on.ca/fr/expositions-et-galeries/expositions/t-rex-le-predateur-supreme>. Une exposition qui vous fera découvrir le tyrannosaure... du tout-petit au colosse. Réservez vos billets sur rom.ca/fr<https://www.rom.on.ca/fr>. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.