Create a record set from external list of catalog numbers

Get Help
1

I wonder if it’s possible to use a external list of Catalog number to create these Record Sets?
For example, an external researcher has made a very precise list of around 50 specimens corresponding to his particular research needs. He sends me the list of catalogue numbers by email or by csv. From my side, can I call up this list in one way or another or do I create this record set by manually entering the 50 specimens (knowing that with a Query it is not possible to recreate the list of selected specimens)?

2

Hi @Marion

Not sure if I understand your question correctly, but you could create a query based on a precise list of 50 catalog numbers by using the in operator in the query builder, and then converting those query results to a record set as shown above. If the catalogue numbers were emailed in a csv (most likely in a column), you can convert them into the format Specify wants in excel using the following (replace A with the column the numbers are in). Then, copy and paste the resulting cell into the input box.[1]

=TEXTJOIN(",",TRUE,A:A)

image
image1743×929 24.9 KB

  1. Alternatively, if you are a fan of the command line, could do something similar with some shell commands ↩︎

3

That’s exactly it! Thanks a lot @markp !

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.